Ian A. Newby schrieb:

>
> Hi Urs,
>
> I have a stored procedure to do what you want. It requires some of the
> standard UDFs to do what you want. It may not be much better however.
>

Hi Ian,

didn't examine your SP closely, but it should be better since it does
everything in one place - without the need of passing parameters all the
time.
But I'd prefer realizing it in an UDF because I can access the function
also from an application.


Can anybody tell me about the performance comparison doing such
operations in PSQL compared to UDFs?

Urs