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 73F989FB1BE
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 20 Jul 2006 18:12:43 -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 74568-01-2 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 20 Jul 2006 18:12:40 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from pd6mo1no.prod.shaw.ca (idcmail-mo2no.cg.shawcable.net
	[64.59.134.9]) by postgresql.org (Postfix) with ESMTP id 3C1AF9FA379
	for <pgsql-sql@postgresql.org>; Thu, 20 Jul 2006 17:45:34 -0300 (ADT)
Received: from pd8mr8no.prod.shaw.ca
	(pd8mr8no-qfe2.prod.shaw.ca [10.0.144.229]) by l-daemon
	(Sun ONE Messaging Server 6.0 HotFix 1.01 (built Mar 15 2004))
	with ESMTP id <0J2P00ES3YZXJN80@l-daemon> for pgsql-sql@postgresql.org;
	Thu, 20 Jul 2006 14:45:33 -0600 (MDT)
Received: from pn7ml4no.prod.shaw.ca ([10.0.149.113])
	by pd8mr8no.prod.shaw.ca (Sun ONE Messaging Server 6.0 HotFix 1.01
	(built Mar
	15 2004)) with ESMTP id <0J2P0026JYZX8Z50@pd8mr8no.prod.shaw.ca> for
	pgsql-sql@postgresql.org; Thu, 20 Jul 2006 14:45:33 -0600 (MDT)
Received: from Dell4500 ([24.77.157.242])
	by l-daemon (Sun ONE Messaging Server 6.0 HotFix 1.01 (built Mar 15
	2004))
	with SMTP id <0J2P006YGYZPJT00@l-daemon> for pgsql-sql@postgresql.org;
	Thu, 20 Jul 2006 14:45:33 -0600 (MDT)
Date: Thu, 20 Jul 2006 15:45:34 -0500
From: George Weaver <gweaver@shaw.ca>
Subject: Re: Error when trying to use a FOR loop
To: Kevin Nikiforuk <Kevin.Nikiforuk@Acrodex.com>, pgsql-sql@postgresql.org
Message-id: <005301c6ac3d$735dd6b0$6400a8c0@Dell4500>
MIME-version: 1.0
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-Mailer: Microsoft Outlook Express 6.00.2900.2869
Content-type: text/plain; format=flowed; charset=iso-8859-1;
	reply-type=original
Content-transfer-encoding: 7bit
X-Priority: 3
X-MSMail-priority: Normal
References: <6EA72AC41F81D242A38AAF505523A94D022DF2@kappa.acrodex.net>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=1.918 tagged_above=0 required=5
	tests=DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, SPF_PASS
X-Spam-Level: *
X-Archive-Number: 200607/268
X-Sequence-Number: 25842


----- Original Message From: "Kevin Nikiforuk"

<snip>

>xp512-0715-0716=# FOR LV in 1..10 LOOP

<snip>

It appears that you are trying to use the For .. Loop structure from the 
psql command line.  This structure is not plain SQL - its meant to be used 
within PL/pgSQL.  Have you tried incorporating it into a PL/pgSQL function?

See 
http://www.postgresql.org/docs/8.1/static/plpgsql-control-structures.html#PLPGSQL-CONTROL-STRUCTURES-LOOPS

Regards,
George