Re: [HACKERS] patch: xmltable - proof concept

2016-08-09 19:30 GMT+02:00 Alvaro Herrera : > Pavel Stehule wrote: > > > postgres=# SELECT xmltable.* > > postgres-#FROM (SELECT data FROM xmldata) x, > > postgres-# LATERAL xmltable('/ROWS/ROW' > > postgres(# PASSING data > >

Re: [HACKERS] patch: xmltable - proof concept

Pavel Stehule wrote: > postgres=# SELECT xmltable.* > postgres-#FROM (SELECT data FROM xmldata) x, > postgres-# LATERAL xmltable('/ROWS/ROW' > postgres(# PASSING data > postgres(# COLUMNS id int PATH '@id', > postgres(#

Re: [HACKERS] patch: xmltable - proof concept

Hi 2016-08-07 11:15 GMT+02:00 Pavel Stehule : > Hi > > I am sending a initial implementation of xmltable function: > > The code is not clean now, but it does almost of expected work. The usage > is simple. It is fast - 16K entries in 400ms. > > I invite any help with

[HACKERS] patch: xmltable - proof concept

Hi I am sending a initial implementation of xmltable function: The code is not clean now, but it does almost of expected work. The usage is simple. It is fast - 16K entries in 400ms. I invite any help with documentation and testing. The full ANSI/SQL, or Oracle compatible implementation is not