Re: [INTERFACES] Bug in parser? - Mailing list pgsql-interfaces

From Ed Loehr
Subject Re: [INTERFACES] Bug in parser?
Date
Msg-id 389B88ED.DF613747@austin.rr.com
Whole thread Raw
In response to Bug in parser?  (Richard <blackw@sfu.ca>)
List pgsql-interfaces
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


pgsql-interfaces by date:

Previous
From: Richard
Date:
Subject: Bug in parser?
Next
From: Phillip Rhodes
Date:
Subject: jdbc question