Passing tokens to a function - Mailing list pgsql-general

From Scott Bailey
Subject Passing tokens to a function
Date
Msg-id 4A164FC1.5010303@comcast.net
Whole thread Raw
Responses Re: Passing tokens to a function  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I'd like to make an XMLTABLE() function, probably in plpython (not C).
And I'd like to follow the SQL/XML standard. So a function call should
look something like this:

SELECT *
FROM XMLTABLE('//node'
   PASSING xmldoc
   COLUMNS id INT PATH '@id',
     name VARCHAR(30) PATH 'name')

Is this possible to pass in the tokens or do I need to abandon the
standard and just take parameters, probably something more like:

SELECT *
FROM XMLTABLE('//node', xmldoc,
array[xt_column('id', INT, '@id'), xt_column('name', VARCHAR(30), 'name')])

pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: How to restore a SQL-ASCII encoded database to a new UTF-8 db?
Next
From: Tommy Gildseth
Date:
Subject: Re: How to restore a SQL-ASCII encoded database to a new UTF-8 db?