Re: Suggestions for the best strategy to emulate returning multiple sets of results - Mailing list pgsql-general

From Merlin Moncure
Subject Re: Suggestions for the best strategy to emulate returning multiple sets of results
Date
Msg-id CAHyXU0wWUM45cGh-3XgVgvnTPXiSaR0BxbqOHTCDC3c+rZgBUQ@mail.gmail.com
Whole thread Raw
In response to Re: Suggestions for the best strategy to emulate returning multiple sets of results  (Seref Arikan <serefarikan@kurumsalteknoloji.com>)
Responses Re: Suggestions for the best strategy to emulate returning multiple sets of results  (Seref Arikan <serefarikan@kurumsalteknoloji.com>)
List pgsql-general
On Mon, Oct 8, 2012 at 4:59 PM, Seref Arikan
<serefarikan@kurumsalteknoloji.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


pgsql-general by date:

Previous
From: Shaun Thomas
Date:
Subject: Re: Storing large files in multiple schemas: BLOB or BYTEA
Next
From: Seref Arikan
Date:
Subject: Re: Suggestions for the best strategy to emulate returning multiple sets of results