Re: Checking if Aggregate exists

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Josh Trutwin <josh(at)trutwins(dot)homeip(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Checking if Aggregate exists
Date: 2008-03-24 18:09:50
Message-ID: 20080324180950.GA25438@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)svana(dot)org> http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2008-03-24 18:17:55 Re: Checking if Aggregate exists
Previous Message Josh Trutwin 2008-03-24 17:47:43 Checking if Aggregate exists