On Sat, Feb 24, 2007 at 11:35:10PM -0500, Gene wrote: > Is there a way to get the benefit of using ascii and the "C" locale > for index usage on certain tables and unicode encoding on others > (where peformance is not an issue)? In particular the planner will > not use index with Unicode on "like '123%' " queries.
See "Operator Classes" in the "Indexes" chapter of the documentation. http://www.postgresql.org/docs/8.2/interactive/indexes-opclass.html -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq