Skip site navigation (1) Skip section navigation (2)

Jagged Rows (was Re: Proposal: real procedures again(8.4))

From: David Fetter <david(at)fetter(dot)org>
To: Zeugswetter Andreas ADI SD <Andreas(dot)Zeugswetter(at)s-itsolutions(dot)at>
Cc: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>,Gregory Stark <stark(at)enterprisedb(dot)com>,Hannu Krosing <hannu(at)skype(dot)net>, Josh Berkus <Josh(dot)Berkus(at)sun(dot)com>,Merlin Moncure <mmoncure(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Jagged Rows (was Re: Proposal: real procedures again(8.4))
Date: 2007-10-30 15:11:00
Message-ID: 20071030151100.GW14638@fetter.org (view raw or flat)
Thread:
Lists: pgsql-hackers
On Tue, Oct 30, 2007 at 03:24:20PM +0100, Zeugswetter Andreas ADI SD wrote:
> > > I think the cool thing that Josh Berkus wants is
> > >
> > > return query select a, b, c from foo;
> > > return query select d, e, f from bar;
> > >
> > 
> > maybe better
> > 
> > SELECT a,b FROM foo;
> > SELECT d, e FROM bar;
> > 
> > procedure doesn't need return statement usually
> 
> The background for Quel was, that when selecting all fields from an
> inheritance hierarchy you got the additional fields of each child.
> 
> Thus the field count and types could vary within one cursor.
> Like if you would allow the following:
> select a, b::int from foo 
> union all
> select a, c::varchar, d, e from bar

This is called jagged rows, which were in Illustra, Informix, and
possibly some others.  It would be nice to have protocol-level support
for them, but it's a pretty large feature because the current Postgres
code starts off with the assumption that you know at run time the
shape of all the rows and that that shape is uniform.

Cheers,
David.
-- 
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

In response to

pgsql-hackers by date

Next:From: Filip RembiaƂkowskiDate: 2007-10-30 16:09:01
Subject: Re: URGENT HELP about 'duration' stats
Previous:From: David FetterDate: 2007-10-30 15:06:18
Subject: Per-statement Triggers (was Re: Proposal: realprocedures again (8.4))

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group