UPDATE... RETURNING AFTER/BEFORE

From: Karol Trzcionka <karlikt(at)gmail(dot)com>
To: pgsql-students(at)postgresql(dot)org
Subject: UPDATE... RETURNING AFTER/BEFORE
Date: 2013-06-28 20:12:49
Message-ID: 51CDEE41.5030606@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-students by date

  From Date Subject
Next Message Stas Kelvich 2013-06-28 20:17:38 Cube extension, week #1 report
Previous Message Alexander Korotkov 2013-06-28 20:11:16 Re: GSoC Progress Reports?