From: Zuev Dmitry <envoy1@chat.ru>
To: pgsql-sql@postgresql.org
Subject: How can I retrieve an info about function arguments ?
Date: Thu, 24 Oct 2002 18:35:21 +0700
Message-ID: <ap8luc$15t$1@news.nsk.su> (raw)
Hello All
Consider a function:
create function f(varchar(10), decimal(10,1)) returns integer as 'select 1;'
language sql;
I need to retreive full set of info about argument and return types (for
variable length too).
How I can get it from system catalog ?
For tables columns I can gen an info from pg_attribute table. But in case of
function no entry are present there.
pg_proc has no info about length of variable length types.
__________________________________________________________________ Dmitry
Vitalievitch ICQ#: 11000008 Current ICQ status: + More ways to contact me
__________________________________________________________________
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: envoy1@chat.ru
Subject: Re: How can I retrieve an info about function arguments ?
In-Reply-To: <ap8luc$15t$1@news.nsk.su>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox