Re: pl/pgsql and returns timestamp type

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pl/pgsql and returns timestamp type
Дата
Msg-id 21392.1031686049@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pl/pgsql and returns timestamp type  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-novice
Josh Berkus <josh@agliodbs.com> writes:
>> But then... How could I obtain "variable global values" (like the timestamp
>> for example) in different function locations whit its "at time" values ???

> Not that I know of.   I'd suggest, instead, that you call the second now()
> statement after the function completes.

There is a function that gives true realtime, rather than transaction
start time as now() does.  I think it's called timeofday(), but check
the manual.

            regards, tom lane

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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: pl/pgsql and returns timestamp type
Следующее
От: Terry Yapt
Дата:
Сообщение: Re: pl/pgsql and returns timestamp type