> > Hello, > > What is wrong with this function because the mytime variable contain the > same value in each iteration: > CREATE OR REPLACE FUNCTION public.time_test() > RETURNS int4 AS > ' > DECLARE > count int4; > mytime timestamp; > BEGIN > count := 0; > mytime := now(); > while count <= 25 loop > mytime := now(); > RAISE NOTICE \'Time: %\',mytime; > count := count + 1; > end loop; > RAISE NOTICE \'Count: %\',count; > RETURN count; > END; > ' > LANGUAGE 'plpgsql' VOLATILE; > > the result is: > NOTICE: Time: 2003-09-29 15:52:06.745317 > . > . > . > NOTICE: Time: 2003-09-29 15:52:06.745317 --same with the first value!!! > NOTICE: Count: 26 > > Thanks. > Change mytime := now(); to mytime := ''now''; and RTFM for details.
Regards, Christoph ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
