Thread: Using SHOW in PL/pgSQL

Hi everybody

I have a brief question. It it just a simple yet annoying problem.
How can I use SHOW to retrieve a value inside a PL/pgSQL function?

I am looking for something like that:

SELECT enable_seqscan;

Is there a system table where I can find all the values on 7.2.3?
It seems as if there was no way to use SHOW in a subselect.

Any ideas to solve this problem efficiently.

    Hans

--
*Cybertec Geschwinde u Schoenig*
Ludo-Hartmannplatz 1/14, A-1160 Vienna, Austria
Tel: +43/1/913 68 09; +43/664/233 90 75
www.postgresql.at <http://www.postgresql.at>, cluster.postgresql.at
<http://cluster.postgresql.at>, www.cybertec.at
<http://www.cybertec.at>, kernel.cybertec.at <http://kernel.cybertec.at>

=?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= <hs@cybertec.at> writes:
> I have a brief question. It it just a simple yet annoying problem.
> How can I use SHOW to retrieve a value inside a PL/pgSQL function?

In 7.3 there are SQL function calls equivalent to SHOW and SET.
I think using those is probably the only way, short of hacking on
plpgsql.

            regards, tom lane