From: | Zoltan Boszormenyi <zboszor(at)dunaweb(dot)hu> |
---|---|
To: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: SERIAL type feature request |
Date: | 2005-12-05 18:03:41 |
Message-ID: | 439480FD.1060802@dunaweb.hu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Jan Wieck írta:
> On 12/4/2005 5:10 PM, Zoltan Boszormenyi wrote:
>
>> I found this in the SQL2003 draft:
>>
>> "
>> 4.14.7 Identity columns
>>
>> ... An identity column has a start value, an increment, a maximum
>> value, a minimum value,
>> and a cycle option. ...
>> "
>>
>> The exact properties of a sequence. It would be a good idea to be
>> able to provide
>> all these the same way PostgreSQL provides CREATE SEQUENCE.
>
>
> I think nobody would object to implementing support for the SQL2003
> syntax. Most of that would be providing all the values that will get
> forwarded into the internal sequence generation during CREATE TABLE.
>
> The other thing needed is an extension to the default value mechanism
> that overrides any given value to implement GENERATE ALLWAYS. Not too
> hard either.
Where can I find this syntax? (PDF file name, page#) Thanks.
I think I modify my feature request for the standard behaviour.
Thanks and best regards,
Zoltán Böszörményi
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 2005-12-05 18:09:48 | Re: SERIAL type feature request |
Previous Message | Andrew Dunstan | 2005-12-05 17:53:49 | Re: [PATCHES] snprintf() argument reordering not working |