Search Postgresql Archives

Re: hi, what is wrong with my newbie sql?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"Ronin" <jkoorts@xxxxxxxxx> writes:
> 		k = 10;
> 		FOR k IN 1..10 LOOP
> 			k = k +1;
> 		END LOOP;

> 		return k;

An integer for-loop implicitly declares its control variable, so the "k"
inside the loop is unrelated to the "k" outside.  Hence you get 10.

As for what you'd get if they were the same variable, I dunno why you're
so certain it would be 20.  Munging a loop's control variable by hand is
a good way to trip over undocumented details of the loop implementation.

			regards, tom lane


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux