Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 67A1B6343D1
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed,  4 Mar 2009 20:33:25 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 99541-06 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed,  4 Mar 2009 20:33:21 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from pooka.fabcat.org (pooka.fabcat.org [114.31.201.3])
	by mail.postgresql.org (Postfix) with ESMTP id 448006342AC
	for <pgsql-admin@postgresql.org>; Wed,  4 Mar 2009 20:33:14 -0400 (AST)
Received: from localhost (localhost [127.0.0.1])
	by pooka.fabcat.org (Postfix) with ESMTP id 8A4D43A8002
	for <pgsql-admin@postgresql.org>; Thu,  5 Mar 2009 11:33:10 +1100 (EST)
X-Virus-Scanned: Debian amavisd-new at pooka.fabcat.org
Received: from pooka.fabcat.org ([127.0.0.1])
	by localhost (pooka.fabcat.org [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id r1v9M6eW1GFx for <pgsql-admin@postgresql.org>;
	Thu,  5 Mar 2009 11:33:00 +1100 (EST)
Received: by pooka.fabcat.org (Postfix, from userid 1000)
	id 105073A8001; Thu,  5 Mar 2009 11:32:59 +1100 (EST)
Date: Thu, 5 Mar 2009 11:32:59 +1100
From: raf <raf@raf.org>
To: pgsql-admin@postgresql.org
Subject: Re: getting 'full' names of functions?
Message-ID: <20090305003259.GA24998@raf.org>
Mail-Followup-To: pgsql-admin@postgresql.org
References: <20090302122020.137490@gmx.net> <49ABE46D.3000501@synechron.com>
	<5521.1236006477@sss.pgh.pa.us> <20090304144122.153400@gmx.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20090304144122.153400@gmx.net>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200903/72
X-Sequence-Number: 31572

Jan-Peter.Seifert@gmx.de wrote:

> Hello Ashish, Hello Tom,
> 
> thank you very much for your quick and helpful replies - I really appreciate that.
> 
> > > May be this will help you:
> > 
> > Easier is just
> > 	select oid::regprocedure from pg_proc where <whatever>
> 
> I guess I'll go with the very nifty type cast suggested by Tom though as this covers aggregate functions as well. This possibility should be mentioned in the docs - together with the system information functions http://www.postgresql.org/docs/8.3/interactive/functions-info.html
> 
> Too bad that this function syntax isn't part of information_schema.
> 
> Thank you very much to both of you.
> 

note that this method doesn't produce a complete function
signature. the precision and scale of numerics are not
included in the output. hopefully, that won't matter for
your needs.

cheers,
raf