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.



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx