Jeff MacDonald <jeff@pgsql.com> writes:
> UPDATE members m,payments p SET m.status = 2 WHERE p.paydate > 'now'::datetime - '1 month'::timespan and p.productid
='xxxxxxx' and m.gid = p.gid
> i'm trying to run that query and i'm getting
> "parse error near m"
> but it looks ok to me
OK according to what reference? SQL92 doesn't allow anything but a
simple <table name> between UPDATE and SET --- no aliases, much less
multiple table names.
regards, tom lane