Re: How to create a sequence for an id field

2002-08-20 Thread Egor Egorov
Brian, Monday, August 19, 2002, 11:48:16 PM, you wrote: BJ> I have a SQL statement to create a PostgreSQL table that include a line 'id serial' BJ> This line creates a integer field with a sequence atached to it to create an autonumber In MySQL you can use AUTO_INCREMENT: http://www.mysql.

How to create a sequence for an id field

2002-08-19 Thread Brian Johnson
I have a SQL statement to create a PostgreSQL table that include a line 'id serial' This line creates a integer field with a sequence atached to it to create an autonumber Is there a way to create a SQL statement to accomplish this that would work with both MySQL and PostgreSQL ---