Re: RETURNING MORE THAN ONE CUSTOM TYPE FROM FUNCTION

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: utsav <utsav(dot)pshah(at)tcs(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: RETURNING MORE THAN ONE CUSTOM TYPE FROM FUNCTION
Date: 2012-06-26 16:52:20
Message-ID: CAHyXU0xgbzDrhrpKNw-W3eGCAKwiNtr-49H9LcrvNhGY5NcW-Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jun 20, 2012 at 9:52 PM, utsav <utsav(dot)pshah(at)tcs(dot)com> wrote:
> merlin can u please suggest any solution for achiving this . I have tried
> array but still i am not getting how to return different array and for
> returning array i must have to pass one array in input parameter and that
> only i can return that is where i got stuck .

why not make two set returning functions? the array approach is
useful but may be difficult to use in your case. it is awkward (read:
slow) to construct arrays iteratively and client processing can be
tricky depending on your application stack.

merlin

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Crawford 2012-06-26 17:27:09 Re: Minimal streaming replication
Previous Message utsav 2012-06-26 16:41:33 Re: RETURNING MORE THAN ONE CUSTOM TYPE FROM FUNCTION