Adding Indexes to Functions

Поиск
Список
Период
Сортировка
От Jeff MacDonald
Тема Adding Indexes to Functions
Дата
Msg-id 1065449706.5115.10.camel@milhouse.bignose.ca
обсуждение исходный текст
Ответы Re: Adding Indexes to Functions
Re: Adding Indexes to Functions
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Nested SPI_exec's
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: Adding Indexes to Functions