Content-Type: text/plain;
  charset="iso-8859-1"
From: Philip Yarra <philip@utiba.com>
Organization: Utiba
To: Bruce Momjian <pgman@candle.pha.pa.us>, Richard Huxton <dev@archonet.com>
Subject: Re: Suggested patch to plpgsql docs (7.4beta)
Date: Thu, 4 Sep 2003 10:20:42 +1000
User-Agent: KMail/1.4.3
Cc: pgsql-docs@postgresql.org
References: <200309032311.h83NBmX12468@candle.pha.pa.us>
In-Reply-To: <200309032311.h83NBmX12468@candle.pha.pa.us>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200309041020.42668.philip@utiba.com>

On Thu, 4 Sep 2003 09:11 am, Bruce Momjian wrote:
> Richard Huxton wrote:
> > Addition of one paragraph to the end of section 39.7.3.4 "FOR (integer
> > variant)"
> >
> > Note that this is basically a WHILE loop, so if the lower bound is larg=
er
> > than the upper bound the loop never executes it's contents:
> >   FOR i IN 10..1 LOOP
> >     RAISE NOTICE ''I do not raise a notice %'',i;
> >   END LOOP;
> >
> > I wasn't sure and had to check, so I assume others might find this usef=
ul
> > too.
>
> I figured everyone would assume that.  I know of no language that will
> execute a loop listed as 10 ... 1.

Basic on my first computer suppported it, though the syntax was=20

FOR $i in 10 TO 1 STEP -1
	PRINT $i
NEXT=20

I think it is worth stating explicitly. The apostrophe in "it's" is incorre=
ct=20
though.

Regards, Philip Yarra.