Re: 'now' runtime

Список
Период
Сортировка
От Tom Lane
Тема Re: 'now' runtime
Дата
Msg-id 16835.1112883267@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 'now' runtime  (Karel Zak)
Список 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 по дате отправления:

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient)