Re: Checking if Aggregate exists

Поиск
Список
Период
Сортировка
Искать
От
Alvaro Herrera
Тема
Re: Checking if Aggregate exists
Дата
Msg-id
20080324181755.GH5484@alvh.no-ip.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>
Josh Trutwin wrote:

> Is there a better way to do this?  Maybe a stored proc that eats the
> error message?

Well, you can use a plpgsql function with a BEGIN/EXCEPTION/END block to
"eat" the error message.  However I'm wondering whether you should be
checking the aggregate argument type(s) as well.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
В списке pgsql-general по дате отправления
От: Martijn van Oosterhout
Дата:
От: Erik Jones
Дата:
FAQ