From: Richard <blackw@sfu.ca>
To: pgsql-interfaces@postgresql.org
Subject: Bug in parser?
Date: Fri, 04 Feb 2000 16:37:11 -0800
Message-ID: <389B70B7.D428C352@sfu.ca> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: blackw@sfu.ca
Subject: Re: Bug in parser?
In-Reply-To: <389B70B7.D428C352@sfu.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox