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