On Mon, 24 Nov 2003 10:20:07 -0300 (ART) MaRcElO PeReIrA <[EMAIL PROTECTED]> wrote:
> Hi guys, > > I have a simple table: > > teste=# \d forn > Table "public.forn" > Column | Type | Modifiers > ---------+---------+------------------------------------------------- > ----- > id | integer | not null default > nextval('public.forn_id_seq'::text) > forn_id | integer | > descrip | text | > Why not make forn_id a sequence as well? then you simply call nextval('forn_id_seq') -- Jeff Trout <[EMAIL PROTECTED]> http://www.jefftrout.com/ http://www.stuarthamm.net/ ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])