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 return all the rows that
were deleted ?
Dave
It might be a good example to put into the docs then.
If not, it may be worth the effort to make it work in 8.3.
Thanks,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
