Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

pgsql-hackers by date

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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group