Hi Richard,
You can do the next:
create sequence fish_seq start 100;
create table fish( fishID int default nextval('fDish_seq') not null, fishName varchar(32) not null
);
The action of the above is what you want!
Vladimir
On Fri, 7 Jan 2000, Richard Walker wrote:
> Hello,
>
> In SQLServer, you can do this:
>
> CREATE TABLE fish (
> fishID INTEGER IDENTITY (100, 1) NOT NULL,
> fishName VARCHAR(32) NOT NULL
> );
>
> When inserting into that table, you don't mention the first field
> and it will automatically use add 1 to the last value in that field,
> starting with 100 for the first record.
> If you wanted it to start at 25 and increment by 5, you'd put
> fishID INTEGER IDENTITY (25, 5) NOT NULL.
>
> I'd like to do something similar to this in PostgreSQL, but the
> closest I can get requires that I mention the implicit sequence which
> seems unneccessary hassle:
>
> CREATE TABLE fish (
> fishID INT4 SERIAL
> fishName VARCHAR(32) NOT NULL
> );
>
> SELECT setval('fish_fishID_seq',99);
>
> (Incrementing by 1 is fine by me).
> Is there any way I can do something like:
> fishID INT4 SERIAL (100, 1)
> or
> fishID INT4 SERIAL (START 100) ?
>
> - Rick
>
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
>
>
> ************
>
>