Thread: Auto Increment Help

I am writing a small stamping program and was wondering: what is the best
way to do auto incrementing, or where can I find some good info on the
subject?

 I use MySQL also, and it handles auto-incrementing, but I found postgresql
does not.

I am using the Perl-DBI interface.

Thanks

-
Stephen Lawrence Jr.
logart@dairypower.com

There is a type serial which will auto-increment. . It will create the trigger  automatically.

TC
 
 
 

Stephen Lawrence wrote:

I am writing a small stamping program and was wondering: what is the best
way to do auto incrementing, or where can I find some good info on the
subject?

 I use MySQL also, and it handles auto-incrementing, but I found postgresql
does not.

I am using the Perl-DBI interface.

Thanks

-
Stephen Lawrence Jr.
logart@dairypower.com

-- 
Tony Corrente
http://www.ontarget-systems.com

On Fri, 7 Jul 2000, Stephen Lawrence wrote:
>I am writing a small stamping program and was wondering: what is the best
>way to do auto incrementing, or where can I find some good info on the
>subject?
>
> I use MySQL also, and it handles auto-incrementing, but I found postgresql
>does not.

See datatype "serial"

--
Anthony E. Greene <agreene@pobox.com>
Homepage & PGP Key: <http://www.pobox.com/~agreene/>
Linux: The choice of a GNU Generation <http://www.linux.org/>