[SQL] getting back autonumber just inserted

2005-07-07 Thread mail TechEvolution
hello i ame a newbie to PostGreSQL, I ame using PostGreSQL 8.0 (windowsinstaller) on a xp prof platform i would like to get back the autonumber from the last record inserted, for other SQL db (m$ sql db ...) i could use: SELECT @@ IDENTITY can someone help me by informing me what the SQL sy

Re: [SQL] getting back autonumber just inserted

2005-07-07 Thread mail TechEvolution
, mail TechEvolution wrote: hello i ame a newbie to PostGreSQL, I ame using PostGreSQL 8.0 (windowsinstaller) on a xp prof platform i would like to get back the autonumber from the last record inserted, for other SQL db (m$ sql db ...) i could use: SELECT @@ IDENTITY can someone help me by

Re: [SQL] getting back autonumber just inserted

2005-07-07 Thread mail TechEvolution
THX to all guys, it is working great !! greetZ wes ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])