Re: [SQL] Serial field starting at 100 ?

      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
> 
> 
> ************
> 
>