| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | "J(dot)A(dot)" <postgresql(at)world-domination(dot)com(dot)au>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Erik Wienhold <ewie(at)ewie(dot)name>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: PL/pgSQL doesn't support variables in queries? |
| Date: | 2023-05-03 14:56:24 |
| Message-ID: | b92038e6-87b4-eaa5-9975-2177cd93e505@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael J. Baars | 2023-05-03 15:23:34 | Re: libpq and multi-threading |
| Previous Message | David G. Johnston | 2023-05-03 14:40:19 | Re: PL/pgSQL doesn't support variables in queries? |