topic Re: postgres - psql error when using a for loop in Operating System - HP-UX

postgres - psql error when using a for loop

Kevin Nikiforuk — Wed, 19 Jul 2006 09:46:25 GMT

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?

Re: postgres - psql error when using a for loop

spex — Wed, 19 Jul 2006 09:56:09 GMT

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

Re: postgres - psql error when using a for loop

Kevin Nikiforuk — Wed, 19 Jul 2006 09:57:58 GMT

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
^

Re: postgres - psql error when using a for loop

Peter Godron — Wed, 19 Jul 2006 10:05:22 GMT

Do you have to declare LV?

Re: postgres - psql error when using a for loop

spex — Wed, 19 Jul 2006 10:09:34 GMT

How about just:

SELECT COUNT(*) FROM ldev-rg;

PCS

Re: postgres - psql error when using a for loop

Kevin Nikiforuk — Wed, 19 Jul 2006 11:04:17 GMT

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

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