| From: | sparikh <sparikh(at)carcharging(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: xpath functionerror |
| Date: | 2014-02-26 18:32:44 |
| Message-ID: | 1393439564088-5793740.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Thanks David for your quick response. My original objective was to get the
value of a particular node in xml which is stored as text datatype in the
table.
For example :
<?xml version="1.0"?>
-<settings>-<F999><amperage>16</amperage><amperagesteps/></F9999></settings>
I want to extract the value of amperage as '16'. Like that I may have many
nodes in xml want to get the report to show them in different columns. I
used to do this with oracle using xml functions provided.
Trying to figure out same in postgres.
Thanks again for your help.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/xpath-functionerror-tp5793724p5793740.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Johnston | 2014-02-26 18:35:49 | Re: xpath functionerror |
| Previous Message | Alvaro Herrera | 2014-02-26 16:56:08 | Re: Cancelling of autovacuums considered harmful |