query failed , don't know why

From: Jeff MacDonald <jeff(at)pgsql(dot)com>
To: pgsql-sql(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: query failed , don't know why
Date: 2000-06-23 18:53:45
Message-ID: Pine.BSF.4.21.0006231549310.280-100000@rage.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Lamar Owen 2000-06-23 20:12:07 Re: Mandrake RPMS, was "Building PostgreSQL 7.0.1 documentation"
Previous Message Ed Loehr 2000-06-23 18:16:13 Server process exited with status 139 (meaning?)

Browse pgsql-sql by date

  From Date Subject
Next Message Mitch Vincent 2000-06-23 19:46:13 Speaking of fulltextindex...
Previous Message Bruce Momjian 2000-06-23 18:06:50 Re: Need to improve performance