>>>>> "GS" == Greg Stark <gsstark@mit.edu> writes:
GS> Uhm, under no locale would an index be used for "ts LIKE
GS> '2003-04-%'" unless you have an functional index on ts::text,
GS> which would be kind of weird.
Yes it will. The start of the pattern is fixed text, so the index can
be used. I do it all the time.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera@kciLink.com Rockville, MD +1-301-869-4449 x806
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/