Marc McIntyre <mmcintyre@xxxxxxxxx> writes: > ... Is there a way to perform this efficiently in one query ? No, because you're hoping for an indexscan optimization of a LIKE query, and that can only happen if the pattern is a plan-time constant. regards, tom lane
