Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group