The trouble with dynamic plpgsql functions - Mailing list pgsql-general

From Динар
Subject The trouble with dynamic plpgsql functions
Date
Msg-id 7620362820.20020531135436@yantel.ru
Whole thread Raw
Responses Re: The trouble with dynamic plpgsql functions
List pgsql-general
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???



pgsql-general by date:

Previous
From: "Kaare Rasmussen"
Date:
Subject: www.postgresql.org search not working
Next
From: "Kaare Rasmussen"
Date:
Subject: PostgreSQL search engine (Perl)