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.