Postgres Pro
Downloads
Home   >   mailing lists

query failed , don't know why - Mailing list pgsql-hackers

From Jeff MacDonald
Subject query failed , don't know why
Date
Msg-id Pine.BSF.4.21.0006231549310.280-100000@rage.hub.org
Whole thread Raw
Responses Re: query failed , don't know why
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Ed Loehr
Date:
Subject: Server process exited with status 139 (meaning?)
Next
From: Lamar Owen
Date:
Subject: Re: Mandrake RPMS, was "Building PostgreSQL 7.0.1 documentation"