Re: Checking if Aggregate exists - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Checking if Aggregate exists
Date
Msg-id 20080324180950.GA25438@svana.org
Whole thread Raw
In response to Checking if Aggregate exists  (Josh Trutwin <josh@trutwins.homeip.net>)
Responses Re: Checking if Aggregate exists
List pgsql-general
On Mon, Mar 24, 2008 at 12:47:43PM -0500, Josh Trutwin wrote:
> My code to check if an aggregate exists runs this query:
>
> SELECT * FROM pg_catalog.pg_aggretate WHERE aggfnoid = 'foo'::REGPROC;

Seems to me you'd rather want the proisagg column in pg_proc and forget
about pg_aggregate altogether...

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

Attachment

pgsql-general by date:

Previous
From: Josh Trutwin
Date:
Subject: Checking if Aggregate exists
Next
From: Alvaro Herrera
Date:
Subject: Re: Checking if Aggregate exists