Re: SERIAL type feature request

Поиск
Список
Период
Сортировка
От Zoltan Boszormenyi
Тема Re: SERIAL type feature request
Дата
Msg-id 439480FD.1060802@dunaweb.hu
обсуждение исходный текст
Ответ на Re: SERIAL type feature request  (Jan Wieck <JanWieck@Yahoo.com>)
Ответы Re: SERIAL type feature request
Список 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 по дате отправления: