Re: Using SHOW in PL/pgSQL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hans-Jürgen Schönig <hs(at)cybertec(dot)at>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Using SHOW in PL/pgSQL
Date: 2002-11-27 16:29:42
Message-ID: 18063.1038414582@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= <hs(at)cybertec(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Bartunov 2002-11-27 16:29:43 Re: [GENERAL] FreeBSD, Linux: select, select count(*) performance
Previous Message Tom Lane 2002-11-27 16:28:00 Re: postgresql slow down