Re: Suggestions for the best strategy to emulate returning multiple sets of results

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Seref Arikan <serefarikan(at)kurumsalteknoloji(dot)com>
Cc: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Suggestions for the best strategy to emulate returning multiple sets of results
Date: 2012-10-10 13:06:20
Message-ID: CAHyXU0wWUM45cGh-3XgVgvnTPXiSaR0BxbqOHTCDC3c+rZgBUQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Oct 8, 2012 at 4:59 PM, Seref Arikan
<serefarikan(at)kurumsalteknoloji(dot)com> wrote:
> Thanks Merlin,
> I've tried arrays but plpython does not support returning arrays of custom
> db types (which is what I'd need to do)

hm -- yeah. can your custom types be broken down into plain SQL types
(that is, composite types?). maybe stash the results in global
variable and return it in two calls, or insert into into a tempt
table that drops on commit?

merlin

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Seref Arikan 2012-10-10 13:27:56 Re: Suggestions for the best strategy to emulate returning multiple sets of results
Previous Message Shaun Thomas 2012-10-10 12:56:15 Re: Storing large files in multiple schemas: BLOB or BYTEA