Re: SERIAL type feature request

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