Silke Trissl <[EMAIL PROTECTED]> writes: > I expected, that the variable curtime gets a new time value, each time > the function is called (at least that is what I understood from the > documentation). This works fine, if I test it with > SELECT mylog_test(5, 'test'); > But as soon as I call the funtion from another function (which I need) > the variable curtime does not change anymore.
"now" refers to the transaction start time. You can get at current time of day with the timeofday() function. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend