[CDBI] Using scalar functions with AbstractSearch

Bill Moseley moseley at hank.org
Thu Feb 2 05:23:14 GMT 2006


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.


test=> select * from times where time < now();
 id | name  |          time          
----+-------+------------------------
  1 | hello | 2006-02-01 20:10:53-08
(1 row)

test=> select * from times where time < 'now()';
 id | name  |          time          
----+-------+------------------------
  1 | hello | 2006-02-01 20:10:53-08
(1 row)

-- 
Bill Moseley
moseley at hank.org





More information about the ClassDBI mailing list