Re: Checking if Aggregate exists

Поиск
Список
Период
Сортировка
Искать
От
Martijn van Oosterhout
Тема
Re: Checking if Aggregate exists
Дата
Msg-id
20080324180950.GA25438@svana.org
Ответ на
Список
Дерево обсуждения
Checking if Aggregate exists Josh Trutwin <josh@trutwins.homeip.net>
Re: Checking if Aggregate exists Martijn van Oosterhout <kleptog@svana.org>
Re: Checking if Aggregate exists Erik Jones <erik@myemma.com>
Re: Checking if Aggregate exists Josh Trutwin <josh@trutwins.homeip.net>
Re: Checking if Aggregate exists Erik Jones <erik@myemma.com>
Re: Checking if Aggregate exists Shane Ambler <pgsql@Sheeky.Biz>
Re: Checking if Aggregate exists Alvaro Herrera <alvherre@commandprompt.com>
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      http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while 
> boarding. Thank you for flying nlogn airlines.
В списке pgsql-general по дате отправления
От: Josh Trutwin
Дата:
Сообщение: Checking if Aggregate exists
От: Alvaro Herrera
Дата:
FAQ