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