Bug in parser?

From: Richard <blackw(at)sfu(dot)ca>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Bug in parser?
Date: 2000-02-05 00:37:11
Message-ID: 389B70B7.D428C352@sfu.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Ed Loehr 2000-02-05 02:20:29 Re: [INTERFACES] Bug in parser?
Previous Message Jorge E. Alvarez 2000-02-04 21:08:48 Simple Suggestion