Skip site navigation (1) Skip section navigation (2)

Re: plug-n-play MS SQL Server replacement

From: Rod Taylor <pg(at)rbt(dot)ca>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Christopher Browne <cbbrowne(at)acm(dot)org>,Postgresql Advocacy <pgsql-advocacy(at)postgresql(dot)org>
Subject: Re: plug-n-play MS SQL Server replacement
Date: 2004-02-21 02:29:38
Message-ID: 1077330578.25444.407.camel@jester (view raw or flat)
Thread:
Lists: pgsql-advocacy
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.



In response to

Responses

pgsql-advocacy by date

Next:From: Joshua D. DrakeDate: 2004-02-21 02:31:21
Subject: Re: Question
Previous:From: David CostaDate: 2004-02-21 02:01:16
Subject: Re: Question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group