j. z. wrote
> Hi. I need to apply a postgis aggregate function. Since usual usage throws
> errors, in case of error I need to use the aggregate function with another
> argument to avoid an error
>
> How can I achieve the goal?
You need to create a custom aggregate function.
http://www.postgresql.org/docs/9.2/interactive/sql-createaggregate.html
Which involves creating two normal functions ( though you can possibly
leverage an existing final func ).
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/user-aggregate-with-exception-handling-tp5811279p5811289.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.