471,316 Members | 1,325 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,316 software developers and data experts.

creating index's on functions.


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
CREATE INDEX actitemsXML_idx ON act_items

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

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



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 12 '05 #1
0 850

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Thomas Matthews | last post: by
reply views Thread by Alan Cobban | last post: by
7 posts views Thread by mike | last post: by
19 posts views Thread by Gary Kahrau | last post: by
2 posts views Thread by Martin v. Löwis | last post: by
6 posts views Thread by lawpoop | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.