creating index's on functions.

Поиск
Список
Период
Сортировка
От Jeff MacDonald
Тема creating index's on functions.
Дата
Msg-id 1065449358.5115.4.camel@milhouse.bignose.ca
обсуждение исходный текст
Список pgsql-general
Hi,

I have a table, where one of the columns "extradata" is a gob of XML.
I'd like to be able to create an index on this function.. so i tried
this


CREATE INDEX actitemsXML_idx ON act_items
(pgxml_xpath(extradata,'//RequestInfo/refund_id/text()','',''));

And i got this nice little error

ERROR:  parser: parse error at or near
"'//RequestInfo/refund_id/text()'" at character 66

I tried escaping the single quotes.. that basically leaves me at a psql
prompt with a ', meaning i need to close my quote, but they're all
escaped.

If anyone has any input for adding index's on functions that have single
quotes in them, that would be great.

Thanks.

Jeff.







В списке pgsql-general по дате отправления:

Предыдущее
От: Nagib Abi Fadel
Дата:
Сообщение: databse design tutorial
Следующее
От: "Relaxin"
Дата:
Сообщение: Re: PostgreSQL Beta4 Tag'd and Bundle'd ...