Re: [HACKERS] DELETE RETURNING

2006-09-25 Thread Markus Schaber
Hi, Dave, Dave Cramer wrote: >> I just read the docs about DELETE RETURNING in 8.2, and a small idea >> arised: >> >> INSERT INTO logtable DELETE * FROM lifetable WHERE date<'2006-01-01' >> RETURNING *; >> >> Will this work as expected? > What is your expected result here ? It would return all th

Re: [HACKERS] DELETE RETURNING

2006-09-25 Thread Dave Cramer
On 25-Sep-06, at 4:31 AM, Markus Schaber wrote: Hi, I just read the docs about DELETE RETURNING in 8.2, and a small idea arised: INSERT INTO logtable DELETE * FROM lifetable WHERE date<'2006-01-01' RETURNING *; Will this work as expected? What is your expected result here ? It would retur

[HACKERS] DELETE RETURNING

2006-09-25 Thread Markus Schaber
Hi, I just read the docs about DELETE RETURNING in 8.2, and a small idea arised: INSERT INTO logtable DELETE * FROM lifetable WHERE date<'2006-01-01' RETURNING *; Will this work as expected? It might be a good example to put into the docs then. If not, it may be worth the effort to make it wor