Re: 'now' runtime - Mailing list pgsql-hackers

From Tom Lane
Subject Re: 'now' runtime
Date
Msg-id 16835.1112883267@sss.pgh.pa.us
Whole thread Raw
In response to 'now' runtime  (Karel Zak)
List pgsql-hackers
Karel Zak <> 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


pgsql-hackers by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient)
Next
From: Tom Lane
Date:
Subject: Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient)