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  (Jan Wieck <JanWieck@Yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: Csaba Nagy
Дата:
Сообщение: Re: generalizing the planner knobs
Следующее
От: Bruce Momjian
Дата:
Сообщение: Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits