On Mar 15, 2005, at 23:21, FERREIRA William (COFRAMI) wrote:
i need to know the execution time of a part of my pl/pgsql code so, i tried to use CURRENT_TIME :
<snip />
my function is recursive and the problem is that i always get the same result for each iteration
t_time_d is set at the first iteration and doesn't change
You're probably looking for timeofday(). See the docs at
http://www.postgresql.org/docs/8.0/interactive/functions- datetime.html#FUNCTIONS-DATETIME-CURRENT
Hope this helps.
Michael Glaesemann grzm myrealbox com
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
