On 5/3/23 07:34, J.A. wrote:
Ah - I think I'm starting to follow.
what i was _trying_ to do is this
get value from a column and stick it into a variable.
now select * from a _number_ of tables and return a -multi recordsets-
from this single query. I'm not sure if that is the same terminology, in
pgsql?
So is this possible?
Many things are possible and they are covered in the documentation:
https://www.postgresql.org/docs/current/plpgsql.html
Read through that and you will find your questions answered.
-JA-
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx