Re: [SQL] Common table expression - parsing questions

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 tell there are two DBMS that require it (Postgres, Firebird) and two that don't (SQL Server and

Re: [SQL] Common table expression - parsing questions

the db2 family does not On Sun, Oct 4, 2009 at 2:10 AM, Thomas Kellerer spam_ea...@gmx.net 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

[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

Thomas Kellerer spam_ea...@gmx.net 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

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

2009/10/4 mohammad qoreishy m_qorei...@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?

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

Osvaldo Kussama wrote: 2009/10/4 mohammad qoreishy m_qorei...@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?