"Jim 'Decibel!' Nasby" <jnasby(at)cashnetusa(dot)com> writes:
> WHERE '12814474045' IN (people.home_phone, people.work_phone,
> people.mobile_phone)
> Yeah, not exactly a common case, but at least in 8.1 this was turned
> into a set of ORs. Starting in 8.2 and in current HEAD, the planner
> turns that into:
> Filter: ('12814474045'::text = ANY ((ARRAY[home_phone, mobile_phone,
> work_phone])::text[]))
> Which means automatic seqscan.
It means no such thing.
regards, tom lane