Martijn van Oosterhout wrote:
On Mon, Jun 26, 2006 at 01:00:19PM +0200, lrotger wrote:
I run the following query:
update personal set closed_date = flt_date + 20
from enr inner join personal p on enr.id = p.id_enr
where (...columns from enr, columns from personal...)
I think your problem
I apologize if I'm running an old version (7.2.1) maybe this has been
fixed or maybe it's not a bug but I can't look at the changelogs now.
UPDATE has a non-standard FROM clause where you can do joins etc so
columns from other tables can appear in WHERE.
I run the following query:
update per
