Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.10.1/8.10.1) with ESMTP id e5O4bB126200; Sat, 24 Jun 2000 00:37:11 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id AAA20424; Sat, 24 Jun 2000 00:37:09 -0400 (EDT) To: Jeff MacDonald cc: pgsql-sql@postgresql.org, pgsql-hackers@postgresql.org Subject: Re: [HACKERS] query failed , don't know why In-reply-to: References: Comments: In-reply-to Jeff MacDonald message dated "Fri, 23 Jun 2000 15:53:45 -0300" Date: Sat, 24 Jun 2000 00:37:09 -0400 Message-ID: <20421.961821429@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200006/216 Jeff MacDonald 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 between UPDATE and SET --- no aliases, much less multiple table names. regards, tom lane