> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
