Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: hi, what is wrong with my newbie sql?
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: "Ronin" <jkoorts(at)gmail(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: hi, what is wrong with my newbie sql?
- Date: Wed, 27 Sep 2006 15:21:15 -0400
"Ronin" <jkoorts(at)gmail(dot)com> 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
- References:
- hi, what is wrong with my newbie sql?
- From: Ronin
- hi, what is wrong with my newbie sql?
- Prev by Date: Re: hi, what is wrong with my newbie sql?
- Next by Date: Re: How to create nightly backups in Linux
- Previous by thread: Re: hi, what is wrong with my newbie sql?
- Next by thread: Timestamp with timezone query
- Indexes: