UPDATE... RETURNING AFTER/BEFORE - Mailing list pgsql-students

From Karol Trzcionka
Subject UPDATE... RETURNING AFTER/BEFORE
Date
Msg-id 51CDEE41.5030606@gmail.com
Whole thread Raw
Responses Re: UPDATE... RETURNING AFTER/BEFORE
List pgsql-students
Hello,
the core of the feature is done. It works for simple statements like:
UPDATE foo2 SET bar1=bar1+1 RETURNING before.bar1, after.bar1,
foo2.bar1, foo2.bar1*before.bar1 AS sth;
or
UPDATE foo SET bar = bar || ' __ ' RETURNING md5(after.bar),
md5(before.bar);
However some of regression tests fail (71 of 136) and it is the next
step of my work. The other problem is the performance, it unnecessary
Seq Scan over whole table (values from these scans are not used).
Regards,
Karol Trzcionka


pgsql-students by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: GSoC Progress Reports?
Next
From: Stas Kelvich
Date:
Subject: Cube extension, week #1 report