Adding 'crosstab' variants returning refcursor?

From: Craig Ringer <craig(at)2ndquadrant(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Adding 'crosstab' variants returning refcursor?
Date: 2014-09-01 11:08:22
Message-ID: 540453A6.6030304@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all

Before I have a go at hacking it together I wanted to check: Has anyone
explored modifying crosstab to return a refcursor, so you can FETCH the
results w/o having to specify an explicit result type/descriptor?

Consuming the input in another query is more of a pain, but it'd be
infinitely nicer when you just want the results in a client.

--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Sawada Masahiko 2014-09-01 11:13:32 Re: Concurrently option for reindexdb
Previous Message Andres Freund 2014-09-01 10:55:59 Re: PL/pgSQL 2