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

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/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

Re: [SQL] Common table expression - parsing questions

Thomas Kellerer writes: > the6campbells wrote on 29.09.2009 04:54: >> 2. Do you intend to remove the requirement to include the recursive >> keyword - as other vendors allow > The standard *requires* the keyword. The reason the standard requires the keyword is that the WITH-name scoping rules

[SQL] reading last inserted record withoud any autoincrement field

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.

Re: [SQL] Common table expression - parsing questions

the db2 family does not On Sun, Oct 4, 2009 at 2:10 AM, Thomas Kellerer wrote: > the6campbells wrote on 29.09.2009 04:54: > >> 2. Do you intend to remove the requirement to include the recursive >> keyword - as other vendors allow >> > > The standard *requires* the keyword. > As far as I can tel