Received: from Mail.austin.rr.com (sm2.texas.rr.com [24.93.35.55])
	by hub.org (8.9.3/8.9.3) with ESMTP id VAA22108
	for <pgsql-interfaces@postgresql.org>;
	Fri, 4 Feb 2000 21:18:09 -0500 (EST)
	(envelope-from eloehr@austin.rr.com)
Received: from austin.rr.com ([24.93.36.157]) by Mail.austin.rr.com with
	Microsoft SMTPSVC(5.5.1877.197.19); Fri, 4 Feb 2000 20:08:21 -0600
Sender: ed
Message-ID: <389B88ED.DF613747@austin.rr.com>
Date: Fri, 04 Feb 2000 20:20:29 -0600
From: Ed Loehr <eloehr@austin.rr.com>
X-Mailer: Mozilla 4.7 [en] (X11; U; Linux 2.2.12-20smp i686)
X-Accept-Language: en
MIME-Version: 1.0
To: blackw@sfu.ca
CC: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] Bug in parser?
References: <389B70B7.D428C352@sfu.ca>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Richard wrote:
> 
>  UPDATE ActiveUser SET status=-1
>     WHERE (datetime('today'::date, 'now'::time) - lastrequest) >
>         timespan('10 minutes'::reltime)
> 
>         parser: parser error at or near ""
> 
> Does this appear to be a bug in the libpq++ library?  Am I using SQL
> incorrectly here?  Something else, maybe?

A guess:  try spaces around your '=' operator...that one sometimes
doesn't like being crowded...

Cheers,
Ed Loehr