Equivalent for AUTOINCREMENT?

From: Michelle Konzack <linux4michelle(at)tamay-dogan(dot)net>
To: pgSQL - General <pgsql-general(at)postgresql(dot)org>
Subject: Equivalent for AUTOINCREMENT?
Date: 2008-10-31 02:30:44
Message-ID: 20081031023044.GJ2940@tamay-dogan.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I have a table where I have a serialnumber which shuld be increased be
each INSERT. I know I can use max() to get the highest number, but how
can I use it in a INSERT statement?

There was a message for some month a message describing it on this list
but I do not find the message anymore...

Thanks, Greetings and nice Day/Evening
Michelle Konzack
Systemadministrator
24V Electronic Engineer
Tamay Dogan Network
Debian GNU/Linux Consultant

--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack Apt. 917 ICQ #328449886
+49/177/9351947 50, rue de Soultz MSN LinuxMichi
+33/6/61925193 67100 Strasbourg/France IRC #Debian (irc.icq.com)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-10-31 03:15:41 Re: Are there plans to add data compression feature to postgresql?
Previous Message Michael Hall 2008-10-31 01:45:54 Re: Equivalent for AUTOINCREMENT?