Hello!
How do you get the list of id's? If you get it while some calculating
you may get the list of them (1, 3, 6,...) and then produce the query
select * from tablename where id in (your_list)
Hope this helps,
Nicolay
Maik Trömel wrote:
Hello!
I want to run a shell script with variables under Postgresql.
An example:
I want to make the following query;
select * from tablename where id=1;
select * from tablename where id=2;
select * from tablename where id=3;
select * from tablename where id=4;
.........
Is it possible to do it this way and what is the right syntax. All i've
tried out didn't work.
while i<100 do
select * from tablename where id=i;
i=i+1;
done
Thanks for your help.
Greetings
Maik
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
