Re: NextNumbers Tables
From: Larry Coon <larry_at_assist.org>
Date: Wed, 12 Feb 2003 11:00:15 -0800
Message-ID: <3E4A99BF.599C_at_assist.org>
Date: Wed, 12 Feb 2003 11:00:15 -0800
Message-ID: <3E4A99BF.599C_at_assist.org>
> 2) Set a local variable within the UPDATE:
>
> UPDATE mytable
> set _at_my_next_val = next_val,
> next_val = next_val + 1
> ...
> COMMIT;
Hmm, is the order of evaluation guaranteed? What's to stop
a particular implementation from doing the second one first?
Larry Coon
University of California
larry_at_assist.org
and lmcoon_at_home.com
Received on Wed Feb 12 2003 - 20:00:15 CET