Message-ID: <389B70B7.D428C352@sfu.ca>
Date: Fri, 04 Feb 2000 16:37:11 -0800
From: Richard <blackw@sfu.ca>
Reply-To: blackw@sfu.ca
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: Bug in parser?
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I have a program that executes the following command:

 UPDATE ActiveUser SET status=-1
    WHERE (datetime('today'::date, 'now'::time) - lastrequest) >
    	timespan('10 minutes'::reltime)


("lastrequest" is of type "datetime")

When executed via ExecCommandOk(), I get the following error message
back from ErrorMessage():

	parser: parser error at or near ""

However, if I cut this command from the terminal window in which the
program is running (the command string is dumped to stdout just before
execution), and paste it in psql, it executes just fine.

Does this appear to be a bug in the libpq++ library?  Am I using SQL
incorrectly here?  Something else, maybe?

Thanks in advance.

Cheers,
Richard