| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Scott Bailey <artacus(at)comcast(dot)net> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Passing tokens to a function |
| Date: | 2009-05-22 17:49:29 |
| Message-ID: | 27947.1243014569@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Scott Bailey <artacus(at)comcast(dot)net> writes:
> 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,
The latter, unless you want to modify the parser (see gram.y).
The SQL committee's willingness to invent random syntax like this
is not one of their better habits :-(
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Keith Hayden | 2009-05-22 17:56:48 | Re: How to update stavaluesN columns in pg_statistics (type anyarry) |
| Previous Message | artacus | 2009-05-22 17:23:47 | Re: Aggregate Function to return most common value for a column |