Re: SERIAL type feature request

On 12/5/2005 1:03 PM, Zoltan Boszormenyi wrote:
> 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.

It's all in the Foundation paper inside this zip:

http://www.wiscorp.com/sql/sql_2003_standard.zip

Jan

>
> Thanks and best regards,
> Zoltán Böszörményi
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #