Re: SERIAL type feature request

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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073