X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id B6C219FB354 for ; Thu, 20 Jul 2006 16:54:21 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 59859-01-6 for ; Thu, 20 Jul 2006 16:54:21 -0300 (ADT) X-Greylist: delayed 00:19:15.850407 by SQLgrey- Received: from Saturn.acrodex.com (saturn.acrodex.com [139.142.184.3]) by postgresql.org (Postfix) with ESMTP id 4C2F89FB1E2 for ; Thu, 20 Jul 2006 11:05:55 -0300 (ADT) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Subject: Error when trying to use a FOR loop Date: Thu, 20 Jul 2006 07:46:41 -0600 Message-ID: <6EA72AC41F81D242A38AAF505523A94D022DF2@kappa.acrodex.net> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Error when trying to use a FOR loop Thread-Index: AcasAu4kigmP+DfxTwS5E1tAkwfPzg== From: "Kevin Nikiforuk" To: X-imss-version: 2.041 X-imss-result: Passed X-imss-scores: Clean:38.34733 C:2 M:3 S:5 R:5 X-imss-settings: Baseline:1 C:1 M:1 S:1 R:1 (0.0000 0.0000) X-Archive-Number: 200607/261 X-Sequence-Number: 25835 Sorry if this is in the archives, but I've done a search and couldn't = find anything relevant. I'm running HP's precompiled version of 8.1.3.1 = as part of their Internet Express offering, and I can't seem to run a = for loop. Here's what I'm seeing: xp512-0715-0716=3D# FOR LV in 1..10 LOOP xp512-0715-0716-# select * from ldevrg; ERROR: syntax error at or near "FOR" at character 1 LINE 1: FOR LV in 1..10 LOOP ^ I'm still pretty new to postgres, but based on the documentation I'm not = picking up what I'm doing wrong.=20 Help much appreciated. Thanks, Kevin