doh! tom, let me know if you decide to hack out a fix for this one of these nights ;) thanks for your help. On Feb 19, 2008 9:45 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > "Postgres User" <postgres.developer@xxxxxxxxx> writes: > > Yes that works, but the whole point of the exercise is replace many OR > > statements with 1 regex expression. So it's not what I'm looking for. > > Unfortunately, Postgres is not as intelligent as you are. There is > no mechanism to rewrite a multi-branch regex condition into multiple > indexscans. I recommend going back to the OR's. > > regards, tom lane > ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
