Re: patch: function xmltable

I tried to see if a following RTE was able to "see" the entries created by
XMLTABLE, and sure it can:

SELECT X.*, generate_series 
FROM emp, 
XMLTABLE ('//depts/dept/employee' passing doc 
   COLUMNS 
   empID    INTEGER     PATH '@id',
   firstname    varchar(25)     PATH 'name/first',
   lastname     VARCHAR(25)     PATH 'name/last') AS X,
generate_series(900, empid);

 empid │ firstname │ lastname │ generate_series 
───────┼───────────┼──────────┼─────────────────
   901 │ John      │ Doe      │             900
   901 │ John      │ Doe      │             901
   902 │ Peter     │ Pan      │             900
   902 │ Peter     │ Pan      │             901
   902 │ Peter     │ Pan      │             902
   903 │ Mary      │ Jones    │             900
   903 │ Mary      │ Jones    │             901
   903 │ Mary      │ Jones    │             902
   903 │ Mary      │ Jones    │             903
(9 filas)

Cool.

I'm still wondering how this works.  I'll continue to explore the patch
in order to figure out.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services