[SQL] Re: [HACKERS] query failed , don't know why

[Tom Lane]

Jeff MacDonald <[EMAIL PROTECTED]> 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