[CDBI] Using scalar functions with AbstractSearch

Tatsuhiko Miyagawa miyagawa at gmail.com
Thu Feb 2 05:33:24 GMT 2006


On 2/1/06, Bill Moseley <moseley at hank.org> wrote:
> On Thu, Feb 02, 2006 at 05:54:24AM +0100, Rhesa Rozendaal wrote:
> > I suppose it's my lack of experience with postgresql, but I find it a bit
> > unsettling that placeholder values would be executed instead of used as
> > plain strings. I would not have expected
>
> Does seem odd.

Yeah, it does.

template1=# select * from times where time < 'now()';
 id | name  |            time
----+-------+----------------------------
  1 | hello | 2006-02-02 05:17:29.611499
(1 row)

template1=# select * from times where time < 'noow() ';
ERROR:  invalid input syntax for type timestamp: "noow() "


--
Tatsuhiko Miyagawa




More information about the ClassDBI mailing list