Read up on refcursors - exactly what I wanted, thank you Adrian!
--
View this message in context:
http://postgresql.nabble.com/Dynamic-execution-returning-large-result-sets-tp5929177p5929211.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general
Hi,
I have a function that returns an SQL string as follows:
CREATE OR REPLACE FUNCTION t1() RETURNS text AS
$$
BEGIN
RETURN 'SELECT * FROM mytable';
END
$$ LANGUAGE plpgsql;
and I want to create a second function (t2) that will execute the string
returned by t1() and return the results. I thoug
Hi,
I know a while ago someone posted a patch to support this:
http://blog.2ndquadrant.com/postgresql-9-3-development-array-element-foreign-keys/
but it seems that it has not made it as of 9.5.
Is anyone aware of why it wasn't already included / if it is planned for it
to be in a (near) future re
t a RDBMS provides. It may not be 'the answer'
but I certainly feel it warrants some interest.
Thank you,
Emrul
On Wed, Jun 29, 2011 at 9:37 AM, Radosław Smogura
wrote:
> On Tue, 28 Jun 2011 17:04:54 -0600, Rob Sargent wrote:
>
>> On 06/28/2011 04:52 PM, Greg Smith wr
Hello,
I've just read through a paper here:
http://www.edbt.org/Proceedings/2011-Uppsala/papers/edbt/a12-schiller.pdfabout
multi-tenancy.
They used Postgres for their work and while it is academic and would need
further work I'm just wondering if anyone in the Postgres team is looking at
implemen
