Обсуждение: xpath functions

Поиск
Список
Период
Сортировка

xpath functions

От
Francisco
Дата:
Hi List,
I have installed postgreSQL 8.3 in my Ubuntu Hardy Heron.
I want to use xpath functions (like xpath_table), but I can't. An error appears "xpath_table does not exists".
How could I intregrate xpath funtions with my postgreSQL without reinstalling it?
Any solution?
Thanks ;)

Re: xpath functions

От
Francisco
Дата:
I saw it,but it says:
"Use of many of these functions requires the installation to have been built with configure --with-libxml"
When I installed postgreSQL I did not include this option, have I to reinstall postgresql?


2009/2/19 Osvaldo Kussama <osvaldo.kussama@gmail.com>
2009/2/19 Francisco <ricken11@gmail.com>:
> Hi List,
> I have installed postgreSQL 8.3 in my Ubuntu Hardy Heron.
> I want to use xpath functions (like xpath_table), but I can't. An error
> appears "xpath_table does not exists".
> How could I intregrate xpath funtions with my postgreSQL without
> reinstalling it?
> Any solution?
> Thanks ;)
>


From manual:
"From PostgreSQL 8.3 on, there is XML-related functionality based on
the SQL/XML standard in the core server. That functionality covers XML
syntax checking and XPath queries, which is what this module does, and
more, but the API is not at all compatible."
http://www.postgresql.org/docs/current/interactive/xml2.html

PostgreSQL 8.3 XML Functions:
http://www.postgresql.org/docs/current/interactive/functions-xml.html

Osvaldo



--
Un día te encontré y al otro te perdí

Re: xpath functions

От
Francisco
Дата:
I have executed pg_config and I have the libxml. I think the problem is that xml2 is not enabled, any idea how to enable it?

2009/2/19 Osvaldo Kussama <osvaldo.kussama@gmail.com>
2009/2/19 Francisco <ricken11@gmail.com>:
> I saw it,but it says:
> "Use of many of these functions requires the installation to have been built
> with configure --with-libxml"
> When I installed postgreSQL I did not include this option, have I to
> reinstall postgresql?
>
>
> 2009/2/19 Osvaldo Kussama <osvaldo.kussama@gmail.com>
>>
>> 2009/2/19 Francisco <ricken11@gmail.com>:
>> > Hi List,
>> > I have installed postgreSQL 8.3 in my Ubuntu Hardy Heron.
>> > I want to use xpath functions (like xpath_table), but I can't. An error
>> > appears "xpath_table does not exists".
>> > How could I intregrate xpath funtions with my postgreSQL without
>> > reinstalling it?
>> > Any solution?
>> > Thanks ;)
>> >
>>
>>
>> From manual:
>> "From PostgreSQL 8.3 on, there is XML-related functionality based on
>> the SQL/XML standard in the core server. That functionality covers XML
>> syntax checking and XPath queries, which is what this module does, and
>> more, but the API is not at all compatible."
>> http://www.postgresql.org/docs/current/interactive/xml2.html
>>
>> PostgreSQL 8.3 XML Functions:
>> http://www.postgresql.org/docs/current/interactive/functions-xml.html
>>


Verify with pg_config:
http://www.postgresql.org/docs/current/interactive/app-pgconfig.html

Osvaldo



--
Un día te encontré y al otro te perdí

Re: xpath functions

От
Peter Eisentraut
Дата:
On Thursday 19 February 2009 16:46:42 Francisco wrote:
> Hi List,
> I have installed postgreSQL 8.3 in my Ubuntu Hardy Heron.
> I want to use xpath functions (like xpath_table), but I can't. An error
> appears "xpath_table does not exists".
> How could I intregrate xpath funtions with my postgreSQL without
> reinstalling it?

xpath_table is not the name of a function provided by PostgreSQL.  Check the
documentation for the real names and signatures.