From: Richard Huxton <dev@archonet.com>
To: pgsql-docs@postgresql.org
Subject: Suggested patch to plpgsql docs (7.4beta)
Date: Wed, 3 Sep 2003 18:45:53 +0100
User-Agent: KMail/1.5
MIME-Version: 1.0
Content-Type: text/plain;
  charset="us-ascii"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200309031845.53722.dev@archonet.com>

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.
-- 
  Richard Huxton
  Archonet Ltd