[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