Perhaps I'm supposed to know this, but how can I run a function on
each query result in psql?
I run the query select a,b from foo where x=y; and I would like to
run the function bar(u,v) for each result from the query and using
the values of a and b as parameters to the function.
How can I do that in psql?
for x in select a,b from foo where x=y loop
would be great!
pgsql-novice by date
|Next:||From: A. Kretschmer||Date: 2010-06-15 11:51:33|
|Subject: Re: How to run loop in psql?|
|Previous:||From: Jasen Betts||Date: 2010-06-15 09:14:57|
|Subject: Re: (not so?) silly question|