From: | Christoph Haller <ch(at)rodos(dot)fzk(dot)de> |
---|---|
To: | keresztes_m(at)yahoo(dot)com (Kerv) |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: now() in loop statement |
Date: | 2003-09-29 15:14:39 |
Message-ID: | 200309291314.PAA12563@rodos |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
>
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Achilleus Mantzios | 2003-09-29 15:46:44 | Conditional row grained + FK dependency oriented lazy replication |
Previous Message | Greg Stark | 2003-09-29 15:12:52 | Re: Result set granularity.. |