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???