GET LAST ID INSERT

From: maufaini(at)tiscali(dot)it (Maurizio Faini)
To: pgsql-general(at)postgresql(dot)org
Subject: GET LAST ID INSERT
Date: 2003-09-23 08:24:32
Message-ID: a435bdf8.0309230024.514a3dd7@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a little problem.

there is a way to get last id inserted into db or i have to make a new query?

I explain better my question:

in vbscript using sqlserver2000 i can use this code:

varBookmark=rs.Bookmark
rs.Update
rs.Bookmark=varBookmark

in this way in I the new id just inserted!!!

how can i do this with postgres?
there is a way?

thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David McLoughlin 2003-09-23 09:35:57 table size
Previous Message Dennis Bjorklund 2003-09-23 05:48:33 Re: Foreign key constraint accepted even when not same