Postgres Pro
Downloads
Home   >   mailing lists

Re: reading last inserted record withoud any autoincrement field - Mailing list pgsql-sql

From Osvaldo Kussama
Subject Re: reading last inserted record withoud any autoincrement field
Date
Msg-id 690707f60910041137l340d2873le86d8f3458188471@mail.gmail.com
Whole thread Raw
In response to reading last inserted record withoud any autoincrement field  (mohammad qoreishy <m_qoreishy@yahoo.com>)
Responses Re: reading last inserted record withoud any autoincrement field  (Rob Sargent <robjsargent@gmail.com>)
List pgsql-sql
Tree view 
2009/10/4 mohammad qoreishy <m_qoreishy@yahoo.com>
>
> How can get last inserted record in a table without any autoincrement filed?
> I need to  frequently fetch the last inserted record.
> If I must use the "Cursor" please explain your solution.
>


RETURNING clause?
http://www.postgresql.org/docs/current/interactive/sql-insert.html

Osvaldo

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Common table expression - parsing questions
Next
From: Rob Sargent
Date:
Subject: Re: reading last inserted record withoud any autoincrement field