Re: WITH RECURSIVE ... CYCLE in vanilla SQL: issues with arrays of rows - Mailing list pgsql-hackers

From David Fetter
Subject Re: WITH RECURSIVE ... CYCLE in vanilla SQL: issues with arrays of rows
Date
Msg-id 20081014073244.GC6492@fetter.org
Whole thread Raw
In response to Re: WITH RECURSIVE ... CYCLE in vanilla SQL: issues with arrays of rows  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Mon, Oct 13, 2008 at 07:01:29PM -0400, Tom Lane wrote:
> "Merlin Moncure" <mmoncure@gmail.com> writes:
> > On Mon, Oct 13, 2008 at 9:56 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> >> I'm inclined to apply the patch with binary-coercibility
> >> adjustments and not try to turn RECORD or RECORD[] into
> >> full-fledged polymorphic types.  It's not immediately clear what
> >> the use of that would be anyway.
> 
> > ...meaning, that you would not be able to create a function taking
> > generic 'record' as a parameter?
> 
> Well, you've never been able to do that, although for many of the
> PLs there doesn't seem to be any very fundamental reason why not.
> But I was actually wondering about something beyond that: should we
> have the equivalent of the polymorphic-type behaviors for
> composites?  That would mean rules along the line of "all records
> mentioned in the call and result are the same composite type" and
> "record[] means the array type corresponding to whichever type
> record is".

+1 :)

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

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


pgsql-hackers by date:

Previous
From: KaiGai Kohei
Date:
Subject: Re: Updates of SE-PostgreSQL 8.4devel patches - Patent problems?
Next
From: Heikki Linnakangas
Date:
Subject: Re: There's some sort of race condition with the new FSM stuff