Zoltan Boszormenyi wrote: > 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.
This seems much stranger than a simple setval(), which get got from Oracle. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
