Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 274FF47612D for ; Thu, 24 Oct 2002 07:36:15 -0400 (EDT) Received: from news.hub.org (news.hub.org [64.49.215.80]) by postgresql.org (Postfix) with ESMTP id B9F9647610E for ; Thu, 24 Oct 2002 07:36:14 -0400 (EDT) Received: by news.hub.org (Postfix, from userid 8) id 6186D38241D; Thu, 24 Oct 2002 07:36:13 -0400 (EDT) From: "Zuev Dmitry" X-Newsgroups: comp.databases.postgresql.sql Subject: How can I retrieve an info about function arguments ? Date: Thu, 24 Oct 2002 18:35:21 +0700 Organization: Rinet Corp. News Service, Novosibirsk, Russia Lines: 16 Message-ID: X-Complaints-To: abuse@news.nsk.su X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 To: pgsql-sql@postgresql.org X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/351 X-Sequence-Number: 10068 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 __________________________________________________________________