Re: plug-n-play MS SQL Server replacement

On Fri, 2004-02-20 at 20:52, Josh Berkus wrote:
> Chris,
>
> > Most conspicuously, MySQL is most likely an imitator of Sybase
> > (progenitor of the code that Microsoft sells) in having
> > "autoincrementing columns" as compared to PostgreSQL's notion of
> > "sequence objects."
>
> Nope.   AUTO_INCREMENT is in the SQL 99 spec.    It's actually well-supported
> in the industry.   Eventually we'll probably come up with a command to
> emulate it using sequences so that we can have the SQL-compliance points.

Are you sure about that? A search for AUTO_INCREMENT doesn't give me
anything.

The DB2 style sequence GENERATORs are a part of the 2002 draft.