Received: from rm-rstar.sfu.ca (root@rm-rstar.sfu.ca [142.58.120.21])
	by hub.org (8.9.3/8.9.3) with ESMTP id LAA99416
	for <pgsql-interfaces@postgreSQL.org>;
	Mon, 7 Feb 2000 11:28:25 -0500 (EST) (envelope-from blackw@sfu.ca)
Received: from sfu.ca (jung.psyc.sfu.ca [142.58.172.8])
	by rm-rstar.sfu.ca (8.9.2/8.9.2/SFU-5.0H) with ESMTP id IAA28813
	for <pgsql-interfaces@postgreSQL.org>;
	Mon, 7 Feb 2000 08:28:23 -0800 (PST)
Message-ID: <389EF2A7.565769D0@sfu.ca>
Date: Mon, 07 Feb 2000 08:28:23 -0800
From: Richard <blackw@sfu.ca>
Reply-To: blackw@sfu.ca
X-Mailer: Mozilla 4.5 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Bug in parser?
References: <389B70B7.D428C352@sfu.ca> <389B88ED.DF613747@austin.rr.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Thanks, but nope... didn't help.

Cheers,
Richard

Ed Loehr wrote:
> 
> Richard wrote:
> >
> >  UPDATE ActiveUser SET status=-1
> >     WHERE (datetime('today'::date, 'now'::time) - lastrequest) >
> >         timespan('10 minutes'::reltime)
> >
> >         parser: parser error at or near ""
> >
> A guess:  try spaces around your '=' operator...that one sometimes
> doesn't like being crowded...
> 
> Cheers,
> Ed Loehr