"Postgres User" <postgres(dot)developer(at)gmail(dot)com> 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