[CDBI] Using scalar functions with AbstractSearch

Bill Moseley moseley at hank.org
Thu Feb 2 14:38:09 GMT 2006


On Wed, Feb 01, 2006 at 09:29:00PM -0800, Bill Moseley wrote:
> 
> test=> select now();
>               now              
> -------------------------------
>  2006-02-01 21:26:58.379497-08
> (1 row)
> 
> test=> select 'now()';
>  ?column? 
> ----------
>  now()
> (1 row)

As you might guess at this point, this is why Pg allows that.

test=> select 'now()'::timestamptz; 
          timestamptz          
-------------------------------
 2006-02-02 06:35:22.295175-08
(1 row)


-- 
Bill Moseley
moseley at hank.org





More information about the ClassDBI mailing list