From: | Hans-Jürgen Schönig <hs(at)cybertec(dot)at> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Using SHOW in PL/pgSQL |
Date: | 2002-11-22 08:24:22 |
Message-ID: | 3DDDE9B6.80904@cybertec.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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>
From | Date | Subject | |
---|---|---|---|
Next Message | Damjan Pipan | 2002-11-22 08:56:32 | Re: modifying new tuple on insert in c trigger |
Previous Message | Shridhar Daithankar | 2002-11-22 08:16:44 | Re: PostgreSQL compilation with custom table name |