>>>>> "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/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
