Re: [SQL] reading last inserted record withoud any autoincrement field

2009-10-05 Thread Scott Marlowe
On Sun, Oct 4, 2009 at 1:34 PM, Rob Sargent wrote: > Osvaldo Kussama wrote: >> >> 2009/10/4 mohammad qoreishy >> >>> >>> 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

Re: [SQL] reading last inserted record withoud any autoincrement field

2009-10-04 Thread Rob Sargent
Osvaldo Kussama wrote: 2009/10/4 mohammad qoreishy 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/

Re: [SQL] reading last inserted record withoud any autoincrement field

2009-10-04 Thread Osvaldo Kussama
2009/10/4 mohammad qoreishy > > 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/s

[SQL] reading last inserted record withoud any autoincrement field

2009-10-04 Thread mohammad qoreishy
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.