Re: The trouble with dynamic plpgsql functions
От | Oliver Elphick |
---|---|
Тема | Re: The trouble with dynamic plpgsql functions |
Дата | |
Msg-id | 1022841399.32333.2566.camel@linda обсуждение исходный текст |
Ответ на | The trouble with dynamic plpgsql functions (Динар <dinar@yantel.ru>) |
Список | pgsql-general |
On Fri, 2002-05-31 at 10:54, Динар wrote: > Hello all!!! > Is it bug or it is should be so??? > > I made a dynamic function on plpgsql which calculates the time period > in seconds for a given item. The calculation begins from now untill > the time that is given in field. For the first time everything > calculates ok, but the second query obtains the same result. > > For example I have to calculate time period in seconds from now to > 20:00. > now 10:00. I run query and obtain 36000 seconds. > > after 1 minute I run query and also obtain the same result. > > I checked it twice the function is not cachable. > > What is wrong here??? > You must be using functions such as now() or CURRENT_TIMESTAMP which always return the same value within one transaction. If you want real time within a transaction you must use timeofday(). -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C "How precious also are thy thoughts unto me, O God! how great is the sum of them! If I should count them, they are more in number than the sand; when I awake, I am still with thee." Psalms 139: 17,18
Вложения
В списке pgsql-general по дате отправления: