Hello Michael, Am 2008-10-31 11:15:54, schrieb Michael Hall: > > 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? > > Have a look in the manual for the SERIAL data type. > For fields with a SERIAL data type, you can use DEFAULT in an INSERT > statement.
OK, the SERIAL is now working, but there is ONE problem.
If the INSERT fails, the SERIAL is in any case increased...
So this was the reason, why I have tried to use max(serno) and add +1
the get the next value for "serno".
Is there a solution for it?
Since I can use a transaction block if required, there should be no
problem with concurence access.
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)
signature.pgp
Description: Digital signature
