Re: serial column

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