Re: [CDBI] Using scalar functions with AbstractSearch

> On Thu, Feb 02, 2006 at 05:54:24AM +0100, Rhesa Rozendaal wrote:

On 2/1/06, Bill Moseley <moseley@xxxx.xxx> 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 b=
it
> > 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=3D# select * from times where time < 'now()';
 id | name  |            time
----+-------+----------------------------
  1 | hello | 2006-02-02 05:17:29.611499
(1 row)

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

--
Tatsuhiko Miyagawa

_______________________________________________
ClassDBI mailing list
ClassDBI@xxxxx.xxxxxxxxxxxxxxxx.xxx
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi