Postgres Pro
Downloads
Home   >   mailing lists

pg_aggregate weird stuff - Mailing list pgsql-general

From Alexander Cohen
Subject pg_aggregate weird stuff
Date
Msg-id 53C226A4-72B2-11D8-A5E2-000A95B947DC@toomuchspace.com
Whole thread Raw
Responses Re: pg_aggregate weird stuff
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From:
Date:
Subject: Re: More Deadlock Detection on Insert
Next
From: Dexter Tad-y
Date:
Subject: Re: [NEWBIE] need help optimizing this query