Peter Eisentraut írta:
Josh Berkus wrote:
I believe that our SERIAL/SEQUENCE stuff is already in compliance
with the SQL standard for sequences (in SQL03). Why would we change
it?
Because your belief is wrong, but Zoltan's proposal is not getting is
closer.
OK, what does the standard say on SERIAL for specifying the start value?
And about this:
<last serial value was e.g. 307>
insert into mytable (serial_id, ...) values (500, ...);
delete from mytable where serial_id = 500;
In Informix, this is a way to start the next serial value at 501.
Best regards,
Zoltán
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
