Re: Extended SERIAL parsing

On Mon, Jun 12, 2006 at 02:27:31PM +0200, B?sz?rm?nyi Zolt?n wrote:
> > Zoltan Boszormenyi <zboszor(at)dunaweb(dot)hu> writes:
> >> after some experimentation, I came up with the attached patch,
> >> which implements parsing the following SERIAL types:
> >
> > As has been pointed out before, it would be a seriously bad idea to
> > implement the SQL syntax for identity columns without matching the
> > SQL semantics for them. That would leave us behind the eight-ball
> > when we wanted to implement the SQL semantics. Right now we have
> > a useful but non-standard semantics, and a useful but non-standard
> > syntax, and those two should stick together.
>
> Well, I read all sections of 5WD-02-Foundation-2003-09.pdf
> where "identity" appears, here are the list of changes that will
> be needed for an identity column:

Have you read the archives on the recent discussions that have taken
place about whether SERIAL should be a black box or not? IIRC most of
this was all hashed out in that thread.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461