Received: from wallace.ece.rice.edu (root@wallace.ece.rice.edu [128.42.12.154]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA22851 for ; Mon, 7 Feb 2000 12:31:09 -0500 (EST) (envelope-from reedstrm@wallace.ece.rice.edu) Received: by wallace.ece.rice.edu via sendmail from stdin id (Debian Smail3.2.0.102) for pgsql-interfaces@postgresql.org; Mon, 7 Feb 2000 11:17:59 -0600 (CST) Date: Mon, 7 Feb 2000 11:17:59 -0600 From: "Ross J. Reedstrom" To: Richard Cc: pgsql-interfaces@postgresql.org Subject: Re: [INTERFACES] Bug in parser? Message-ID: <20000207111759.D24062@rice.edu> References: <389B70B7.D428C352@sfu.ca> <389B88ED.DF613747@austin.rr.com> <389EF2A7.565769D0@sfu.ca> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii User-Agent: Mutt/1.0i In-Reply-To: <389EF2A7.565769D0@sfu.ca>; from blackw@sfu.ca on Mon, Feb 07, 2000 at 08:28:23AM -0800 Richard - I recently tripped over some whitespace sensitivity (that shouldn't be there!) involving line-endings in queries. Could you try your UPDATE all on one line, and see if that solves it? I haven't been able to replicate my problem with my current set up (in order to file a bug report). It originally happened with a demo system we had set up at a meeting. Once we got back to the office, everything worked fine, of course! We got the same sort of 'paser error at or near ""' line in the log, but when I looked with the right editor, I say that there was a control character (either ^M or ^R, can't remember which) between the quotes. Ross -- Ross J. Reedstrom, Ph.D., NSBRI Research Scientist/Programmer Computer and Information Technology Institute Rice University, 6100 S. Main St., Houston, TX 77005 On Mon, Feb 07, 2000 at 08:28:23AM -0800, Richard wrote: > 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 > > ************ >