[SQL] now() in loop statement

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();

[SQL] Thanks for all replies

Thank you, Kerv ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html