Re: serial column

[Gevik Babakhani <pgdev@xxxxxxxxx>]

On Sun, 2006-09-24 at 13:50 -0700, Bob Pawley wrote:
> I need to develop a serial column that always starts at 1 and is
> sequential even after deletes.
>  
> Any ideas???
>  

Did you try the:

create table tbl
(
	id SERIAL
);

or even with primary key...

create table tbl
(
	id SERIAL primary key
);


-- 
Regards,
Gevik Babakhani