Hello,
it's possible. You have to use varchar_pattern_ops:
CREATE INDEX like_index ON person(name varchar_pattern_ops);
Regards
Pavel Stehule
2007/6/28, Andreas Joseph Krogh <[EMAIL PROTECTED]>:
Hi all.
Anybody knows if the following query will use an index-scan in PG-8.3?
SELECT name FROM person WHERE name LIKE 'and%';
I know this works in "C"-locale, but I need it with UTF-8, probably the rest
of the world soon too...
--
Andreas Joseph Krogh <[EMAIL PROTECTED]>
Senior Software Developer / Manager
------------------------+---------------------------------------------+
OfficeNet AS | The most difficult thing in the world is to |
Karenslyst Allé 11 | know how to do a thing and to watch |
PO. Box 529 Skøyen | somebody else doing it wrong, without |
0214 Oslo | comment. |
NORWAY | |
Tlf: +47 24 15 38 90 | |
Fax: +47 24 15 38 91 | |
Mobile: +47 909 56 963 | |
------------------------+---------------------------------------------+
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
