Re: [GENERAL] function null composite behavior

2015-10-26 Thread Rikard Pavelic
On Sun, 25 Oct 2015 22:31:03 +0100 Rikard Pavelic wrote: > I assume there is no way to get sql like result from plpgsql > function? I should try harder ;) Managed to get it working using array and array_agg. Regards, Rikard -- Rikard Pavelic https://dsl-platform.com/

[GENERAL] function null composite behavior

2015-10-26 Thread Rikard Pavelic
Hi, I'm trying to resolve an issue in production due to difference between composite null handling in plpgsql function. Is there some way to get plain sql behavior regarding null composites within plpgsql? From the example: create type composite as (i int); create table data (i int, c

Re: [GENERAL] function null composite behavior

2015-10-26 Thread dinesh kumar
On Mon, Oct 26, 2015 at 3:34 PM, Rikard Pavelic wrote: > On Sun, 25 Oct 2015 22:31:03 +0100 > Rikard Pavelic wrote: > > > I assume there is no way to get sql like result from plpgsql > > function? > > I should try harder ;) > > Managed to get it working using