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 larger
> > 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 useful
> > 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
FOR $i in 10 TO 1 STEP -1
PRINT $i
NEXT
I think it is worth stating explicitly. The apostrophe in "it's" is incorrect
though.
Regards, Philip Yarra.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
