[Babase] Queries that run forever

Karl O. Pinc kop at meme.com
Wed Apr 4 00:42:58 EDT 2007


On 04/03/2007 11:31:42 PM, Tyler Brock wrote:
> Ok awesome! Also, this is the update query I was trying to run:
> 
> INSERT INTO ranks VALUES (nextval('ranks_rnkid_seq'::regclass),  
> 'PLA', '2003-1-01', '10.0', 'ALM', '1');

I'm looking at it now.

FYI.  It's good form (albiet slower, but who cares) to list
the columns in the INSERT, like:

INSERT INTO ranks (rnkid, sname, date, grp, rnktype, rnk) ...

That way should the column order ever change your code
will still work.

(Also, I never explicitly typcast the nextval argument.
I guess I don't see the point.  I've never thought
about it....)

Karl <kop at meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein



More information about the Babase mailing list