Andrew Gierth wrote: > >>>>> "Bruce" == Bruce Momjian <[email protected]> writes: > > >> The unnest() implementation is largely unrelated to the standard > >> one, which is impossible to provide without LATERAL. > > Bruce> I removed the duplicate item; we can add more details about > Bruce> what additional functionality we need once we get user > Bruce> feedback. > > The missing functionality from the spec is: > > 1) select ... from foo, unnest(foo.bar); -- UNNEST is implicitly LATERAL > > 2) multiple arrays: select * from unnest(a,b); > > 3) expansion of composite arrays: unnest(a) should return as many > columns as there are in the elements of a, not just one composite > column > > 4) WITH ORDINALITY - adds a column to the result with the array index > > 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.
OK, so what should the TODO wording be? -- Bruce Momjian <[email protected]> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
