Re: 'now' runtime

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
Cc: List pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: 'now' runtime
Date: 2005-04-07 14:14:27
Message-ID: 16835.1112883267@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Karel Zak <zakkr(at)zf(dot)jcu(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-04-07 14:20:24 Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient)
Previous Message Tom Lane 2005-04-07 14:11:55 Re: About index_build