Re: SERIAL type feature request

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. ...



And that section says nothing at all about using 0 as a magic value. All 
it says is:

"Let IC be the identity column of BT. When a row R is presented for 
insertion
into BT, if R does not contain a column corresponding to IC, then the 
value V for IC in the row inserted into
BT is obtained by applying the General Rules of Subclause 9.21, 
“Generation of the next value of a sequence
generator”, to SG."

Which is pretty much what we do.

We can't implement everybody's way of doing serial cols, because they 
are simply not all compatible. Next someone will be asking us to do it 
MySQL's way (gods forbid).

cheers

andrew