Re: [GENERAL] xpath functionerror

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 : --16 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

[GENERAL] xpath functionerror

Hi, My current database version is "PostgreSQL 9.1.11 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-3), 64-bit". I am trying to use function xpath in my query and got following error. "ERROR: function xpath(unknown, text) does not exist at character 8 HINT:

Re: [GENERAL] xpath functionerror

sparikh wrote > 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 : > > > > - > > - > > > 16 > > > > > I want to extract the value of amperage as '16'. Like that

Re: [GENERAL] xpath functionerror

sparikh wrote > Hi, > > My current database version is "PostgreSQL 9.1.11 on > x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat > 4.4.7-3), 64-bit". > > I am trying to use function xpath in my query and got following error. > > "ERROR: function xpath(unknown, text) does