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@Yahoo.com #