pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
How can I retrieve an info about function arguments ? 2+ messages / 2 participants [nested] [flat]
* How can I retrieve an info about function arguments ? @ 2002-10-24 11:35 Zuev Dmitry <envoy1@chat.ru> 0 siblings, 1 reply; 2+ messages in thread From: Zuev Dmitry @ 2002-10-24 11:35 UTC (permalink / raw) To: pgsql-sql 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 __________________________________________________________________ ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: How can I retrieve an info about function arguments ? @ 2002-10-26 06:05 Bhuvan A <bhuvansql@myrealbox.com> parent: Zuev Dmitry <envoy1@chat.ru> 0 siblings, 0 replies; 2+ messages in thread From: Bhuvan A @ 2002-10-26 06:05 UTC (permalink / raw) To: pgsql-sql > I need to retreive full set of info about argument and return types (for > variable length too). test_db=>\df+ my_func will serve your need :( > How I can get it from system catalog ? pg_proc.pronargs -- count of arguments pg_proc.proargtypes -- oid(s) of pg_type for appropriate arguments regards, bhuvaneswaran ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-10-26 06:05 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2002-10-24 11:35 How can I retrieve an info about function arguments ? Zuev Dmitry <envoy1@chat.ru> 2002-10-26 06:05 ` Bhuvan A <bhuvansql@myrealbox.com>
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