Re: Freezing localtimestamp and other time function on some value

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Freezing localtimestamp and other time function on some value
Дата
Msg-id CAKFQuwZv0FzN68PR9nZ_xyoV-sdhYXzqnTkgv7jUd5KWrwbdyA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Freezing localtimestamp and other time function on some value  (Alex Ignatov <a.ignatov@postgrespro.ru>)
Список pgsql-general
Дерево обсуждения
On Wed, Apr 13, 2016 at 10:14 AM, Alex Ignatov <a.ignatov@postgrespro.ru> wrote:
Some quick and dirty issue resolution is simple:
set search_path = my_time_schema on db layer. After that you dont need to change any code. And can take for example freeze.fixed_date from config =)
where my_time_schema contains all time function than I want to freeze.
Nevertheless i dont know how to deal with say localtimestamp with this approach %). Where localtimestamp is defined? pg_catalog doesnt have it

Some thoughts about localtimestamp redifinition with search_path?

​"localtimestamp" isn't really a function but a keyword​
 
​that somewhat behaves as one.


​Specifically those defined in 9.9.4​

The fact that they can be used without adding the parenthesis is a big give-away.  All true functions must use them.  Note that these time function do allow parentheses but they have a different meaning - to specify precision as opposed to passing arguments - though the do look similar.

​David J.​
​

В списке pgsql-general по дате отправления:

Предыдущее
От: Alex Ignatov
Дата:
Сообщение: Re: Freezing localtimestamp and other time function on some value
Следующее
От: Daniel Lenski
Дата:
Сообщение: sign function with INTERVAL?