Re: Optimising "in" queries

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Russell Smith wrote:

Filter: (sensor_id = ANY ('{1137,1138,1139,1140}'::integer[]))

I've never seen this plan item except for when array's are involved. I could be wrong. I'd like to know how this is generated when you don't have an array.


I have just discovered that PG 8.2 will turn an IN clause into an array search instead of an OR list. Sorry all.

Regards

Russell Smith

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux