On Thu, 20 Jul 2006, Kevin Nikiforuk wrote: > 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=# 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 think the problem is that the FOR is a pl/pgsql construct and isn't allowed in straight sql contexts but only inside a function. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
