pg_aggregate weird stuff

From: Alexander Cohen <alex(at)toomuchspace(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_aggregate weird stuff
Date: 2004-03-10 16:45:24
Message-ID: 53C226A4-72B2-11D8-A5E2-000A95B947DC@toomuchspace.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Im trying to get a list of aggregate names. So i do "SELECT aggfnoid
FROM pg_aggregate" to get a list of Oid of the functions. But this
column seems to return names and not Oid's of the procs. Is this
normal, how can i get a loist of proc Oid's for the aggregtates?

thanks!
--
Alexander Cohen
http://www.toomuchspace.com
(819) 348-9237
(819) 432-3443

Responses

Browse pgsql-general by date

  From Date Subject
Next Message wespvp 2004-03-10 16:47:17 Re: More Deadlock Detection on Insert
Previous Message Dexter Tad-y 2004-03-10 16:43:30 Re: [NEWBIE] need help optimizing this query