Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 110CB632427
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed,  4 Mar 2009 10:41:32 -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 78651-02 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed,  4 Mar 2009 10:41:28 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail.gmx.net (mail.gmx.net [213.165.64.20])
	by mail.postgresql.org (Postfix) with SMTP id E994A632220
	for <pgsql-admin@postgresql.org>; Wed,  4 Mar 2009 10:41:24 -0400 (AST)
Received: (qmail 20862 invoked by uid 0); 4 Mar 2009 14:41:22 -0000
Received: from 192.124.237.8 by www138.gmx.net with HTTP;
	Wed, 04 Mar 2009 15:41:22 +0100 (CET)
Cc: pgsql-admin@postgresql.org
Content-Type: text/plain; charset="iso-8859-1"
Date: Wed, 04 Mar 2009 15:41:22 +0100
From: Jan-Peter.Seifert@gmx.de
In-Reply-To: <5521.1236006477@sss.pgh.pa.us>
Message-ID: <20090304144122.153400@gmx.net>
MIME-Version: 1.0
References: <20090302122020.137490@gmx.net> <49ABE46D.3000501@synechron.com>
	<5521.1236006477@sss.pgh.pa.us>
Subject: Re: getting 'full' names of functions?
To: Tom Lane <tgl@sss.pgh.pa.us>, ashishka@synechron.com
X-Authenticated: #955937
X-Flags: 0001
X-Mailer: WWW-Mail 6100 (Global Message Exchange)
X-Priority: 3
X-Provags-ID: V01U2FsdGVkX189TwkhmVs9w/4giypnUpPkPzFkh19EluuNX+Ccfm
	tppfgKGhF4Tzc/L23UCpToDx/1k8qNcec1Ow==
Content-Transfer-Encoding: 8bit
X-GMX-UID: IKqdcdkPMmA6T0r6ZWFnB7o5MjQ1N13m
X-FuHaFi: 0.75
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/43
X-Sequence-Number: 31543

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.

Peter
-- 
Computer Bild Tarifsieger! GMX FreeDSL - Telefonanschluss + DSL
für nur 17,95 ¿/mtl.!* http://dsl.gmx.de/?ac=OM.AD.PD003K11308T4569a