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

Re: Values list-of-targetlists patch for comments (was Re:

From: Joe Conway <mail(at)joeconway(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Christopher Kings-Lynne <chris(dot)kings-lynne(at)calorieking(dot)com>, "Patches (PostgreSQL)" <pgsql-patches(at)postgresql(dot)org>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Bernd Helmle <mailings(at)oopsware(dot)de>, Peter Eisentraut <peter_e(at)gmx(dot)net>, Susanne Ebrecht <susanne(dot)ebrecht(at)credativ(dot)de>
Subject: Re: Values list-of-targetlists patch for comments (was Re:
Date: 2006-07-24 21:22:29
Message-ID: 44C53A15.9030509@joeconway.com (view raw or flat)
Thread:
Lists: pgsql-docspgsql-hackerspgsql-patches
Tom Lane wrote:
> ISTM that this should be represented using an RTE_SUBQUERY node in the
> outer query; the alias attaches to that node, not to the VALUES itself.
> So I don't think you need that alias field in the jointree entry either.
> 
> If we stick with the plan of representing VALUES as if it were SELECT *
> FROM (valuesnode), then this approach would make the second query above
> have a structure like
> 
> 	Query
> 	  .rtable ->	RTE_SUBQUERY
> 			  .subquery ->	Query
> 					  .jointree ->	Values
> 
> (leaving out a ton of detail of course, but those are the key nodes).
> 

OK, I'll go try to wrap my mind around that this evening and see where 
it takes me.

Thanks,

Joe

In response to

pgsql-docs by date

Next:From: Markus SchiltknechtDate: 2006-07-25 11:33:44
Subject: Re: Replication - super-draft
Previous:From: Tom LaneDate: 2006-07-24 17:09:29
Subject: Re: Values list-of-targetlists patch for comments (was Re: [HACKERS] 8.2 features?)

pgsql-hackers by date

Next:From: Simon RiggsDate: 2006-07-24 21:23:53
Subject: Re: effective_cache_size is a real?
Previous:From: Peter EisentrautDate: 2006-07-24 21:19:43
Subject: Re: TODO: Mark change-on-restart-only values in

pgsql-patches by date

Next:From: Alvaro HerreraDate: 2006-07-24 22:27:29
Subject: Re: The vacuum-ignore-vacuum patch
Previous:From: Robert LorDate: 2006-07-24 21:00:46
Subject: Re: [PATCHES] Generic Monitoring Framework with DTrace patch

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