Re: hi, what is wrong with my newbie sql? - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: hi, what is wrong with my newbie sql?
Date
Msg-id 20060927191431.GA31123@KanotixBox
Whole thread Raw
In response to hi, what is wrong with my newbie sql?  ("Ronin" <jkoorts@gmail.com>)
List pgsql-general
Ronin <jkoorts@gmail.com> schrieb:

> Hi, the following sql returns "10" and not "20" as would be expected.
>
> Where is the error? This would for sure work in any programming
> language, why is this different?
>
> CREATE FUNCTION test () RETURNS INTEGER AS '
>
>     DECLARE
>         k integer;
>
>     BEGIN
>         k = 10;
>         FOR k IN 1..10 LOOP
>             k = k +1;
>         END LOOP;
>
>         return k;
>     END;

I think, the inner k = k + 1; is not visible outer. The loop runs from
k=1 to k=10, and the returning k is the last loop-value k, 10.

You need a extra variable for the loop-counter.


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."    (unknow)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: [HACKERS] PostgreSQL HA questions
Next
From: Tom Lane
Date:
Subject: Re: hi, what is wrong with my newbie sql?