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: (view raw or whole 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



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-2015 The PostgreSQL Global Development Group