Re: SERIAL type feature request - Mailing list pgsql-hackers

From Zoltan Boszormenyi
Subject Re: SERIAL type feature request
Date
Msg-id 439480FD.1060802@dunaweb.hu
Whole thread Raw
In response to Re: SERIAL type feature request  (Jan Wieck <JanWieck@Yahoo.com>)
Responses Re: SERIAL type feature request
List 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



pgsql-hackers by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: generalizing the planner knobs
Next
From: Bruce Momjian
Date:
Subject: Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits