Thread: Re: function null composite behavior

Re: function null composite behavior

From
Rikard Pavelic
Date:
On Sun, 25 Oct 2015 22:31:03 +0100
Rikard Pavelic <rikard@ngs.hr> 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/
http://templater.info/


Re: function null composite behavior

From
dinesh kumar
Date:
On Mon, Oct 26, 2015 at 3:34 PM, Rikard Pavelic <rikard@ngs.hr> wrote:
On Sun, 25 Oct 2015 22:31:03 +0100
Rikard Pavelic <rikard@ngs.hr> 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.

Yeah, that works.

Might be this is what you are looking for.
 
Regards,
Rikard

--
Rikard Pavelic
https://dsl-platform.com/
http://templater.info/


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



--