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

Re: TODO item

From: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: TODO item
Date: 2009-03-28 15:45:58
Message-ID: 87r60hd51l.fsf@news-spur.riddles.org.uk (view raw or flat)
Thread:
Lists: pgsql-hackers
>>>>> "Bruce" == Bruce Momjian <bruce(at)momjian(dot)us> writes:

 >> 1) select ... from foo, unnest(foo.bar);   -- UNNEST is implicitly LATERAL
 [...]
 >> It's point (1) that's the killer - without it, unnest() is just a
 >> trivial shorthand for stuff that can be done anyway; it doesn't
 >> actually add any functionality.

 Bruce> OK, so what should the TODO wording be?

Under "SQL Commands":

 * implement LATERAL (and corresponding UNNEST functionality)

(LATERAL is, I suspect, a fairly big project because of the amount of
planner work involved, but it's also a fairly high-value project
because (a) it's useful (we usually get a couple of cases every week
on the IRC chan where people ask "how do I do X", where X would be
trivial with LATERAL but requires complex and often inefficient SQL
without it), and (b) it potentially presents optimization
opportunities even for queries that don't use it.)

-- 
Andrew.

In response to

Responses

pgsql-hackers by date

Next:From: Robert HaasDate: 2009-03-28 16:06:47
Subject: Re: 8.4 open items list
Previous:From: Andrew GierthDate: 2009-03-28 15:35:01
Subject: Re: TODO item

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