Horton

Re: 'now' runtime

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Karel Zak <zakkr@zf.jcu.cz>
Cc: List pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2005-04-07T14:14:27Z
Lists: pgsql-hackers 
Karel Zak <zakkr@zf.jcu.cz> writes:
> Why is there so different "Total runtime" for ('now'::text)::date) and
> '2005-04-06'::date ?

> I think both is constant during execution.

Not at all. text_date() is not immutable so it has to be applied during
execution.  The other one is just a constant.

			regards, tom lane