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.kla...@aklaver.com



Reply via email to