postgres - psql error when using a for loop

[Kevin Nikiforuk]

Hi there...I've got PostgreSQL A.06.00-8.1.3.1 installed on my server and I'm trying to create a for loop:

for LV in 1..10 LOOP

select * from ldev-rg where rg='$lv';

END LOOP;

but when I run it, I get:

psql:blah.sql:3: ERROR: syntax error at or near "for" at character 1
psql:blah.sql:3: LINE 1: for LV in 1..10 LOOP
psql:blah.sql:3: ^
psql:blah.sql:5: ERROR: syntax error at or near "LOOP" at character 5
psql:blah.sql:5: LINE 1: END LOOP;
psql:blah.sql:5: ^

Am I totally missing something here?

[spex]

Ken,

I don't have much plpgsql experience, but try this:

FOR LV in 1..10 LOOP
SELECT * FROM ldev-rg WHERE rg="$LV";
END LOOP;


PCS

[Kevin Nikiforuk]

Same thing's happening...

xp512-0715-0716=# FOR LV in 1..10 LOOP
xp512-0715-0716-# SELECT * FROM ldev-rg WHERE rg="$LV";
ERROR: syntax error at or near "FOR" at character 1
LINE 1: FOR LV in 1..10 LOOP
^

[Peter Godron]

Do you have to declare LV?

[spex]

How about just:

SELECT COUNT(*) FROM ldev-rg;

PCS

[Kevin Nikiforuk]

My mistake, the table name is actually ldevrg, not ldev-rg.

xp512-0715-0716=# select count(*) from ldevrg;
count
-------
1491
(1 row)