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

Reply via email to