Re: 'now' runtime

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

В списке 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)