"Jim 'Decibel!' Nasby" <[EMAIL PROTECTED]> 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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
