getting value of just inserted rows

[Guest_imported]

Hello all.
Please, help me,

How can I get single field (attribute) value just inserted new row
into the table (by not using select query to find this row)?

(type of that field is serial),

>---
> lexx

 

[Tim1]

Hiya,

Which RDBMS system are you using? Are you using an Autonumber (Identity) column? If so, in Sybase, there is global variable @@identity, which will tell you the last value used, depending on the system you are using, there may be an equivalent.

Tim

 

[Guest_imported]

sorry

I'm using Postgersql database

----
lexx

 

[bperry]

You might have better luck if you post your question in the PostgreSQL forum: forum699