Re: next integer in serial key - Mailing list pgsql-sql

From Oliver Elphick
Subject Re: next integer in serial key
Date
Msg-id 1090474278.25749.173.camel@linda
Whole thread Raw
In response to next integer in serial key  (Kenneth Gonsalves <lawgon@thenilgiris.com>)
List pgsql-sql
On Thu, 2004-07-22 at 03:45, Kenneth Gonsalves wrote:
> hi,
> how does one get the next number in a serial type row?

When inserting a new row, do not mention the serial column in the list
of columns, or else give it the value DEFAULT.

-- 
Oliver Elphick                                          olly@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA  92C8 39E7 280E 3631 3F0E  1EC0 5664 7A2F A543 10EA
========================================   "Then Peter and the other apostles answered and said,      We ought to obey
Godrather than men."                                                Acts 5:29 
 



pgsql-sql by date:

Previous
From: Kenneth Gonsalves
Date:
Subject: next integer in serial key
Next
From: "Chris Cox"
Date:
Subject: LIKE on index not working