Re: 'now' runtime

From: Tom Lane
Subject: Re: 'now' runtime
Date: ,
Msg-id: 16835.1112883267@sss.pgh.pa.us
(view: 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:

From: Tom Lane
Date:
Subject: Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient)
From: "Jim C. Nasby"
Date:
Subject: Re: Recognizing range constraints (was Re: [PERFORM] Plan for relatively simple query seems to be very inefficient)