Re: [CDBI] Using scalar functions with AbstractSearch

>

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@xxxx.xxx

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