Received: from imail.ModemPool.com (imail.modempool.com [198.109.197.28]) by hub.org (8.10.1/8.10.1) with ESMTP id e5NM3M191805 for ; Fri, 23 Jun 2000 18:03:22 -0400 (EDT) Received: from bubba [198.109.197.19] by imail.ModemPool.com (SMTPD32-6.00) id AFE9621500B2; Fri, 23 Jun 2000 18:08:41 -0400 Message-ID: <005501bfdd5f$02633170$0a00a8c0@modempool.com> From: "Brian P. Mann" To: References: Subject: Re: query failed , don't know why Date: Fri, 23 Jun 2000 18:04:31 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6600 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 X-Archive-Number: 200006/972 shouldn't that be m.payments and not m,payments? Brian ----- Original Message ----- From: "Jeff MacDonald" To: ; Sent: Friday, June 23, 2000 2:53 PM Subject: [HACKERS] query failed , don't know why > 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 > > i'm running postgresql 7.0.2 with freebsd 4.0 stable > > jeff > > > >