Re: Regex query not using index

"Postgres User" <postgres.developer@gmail.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