Timeline for Index not used with = ANY() but used with IN

13 events

when toggle format	what		by	license	comment
Jul 25, 2021 at 22:45	history	edited	Erwin Brandstetter	CC BY-SA 4.0	wording; add safe row syntax.
Jan 6, 2019 at 18:38	history	edited	Erwin Brandstetter	CC BY-SA 4.0	format
May 23, 2017 at 12:40	history	edited	CommunityBot		replaced http://stackoverflow.com/ with https://stackoverflow.com/
Apr 13, 2017 at 12:42	history	edited	CommunityBot		replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/
Jan 9, 2016 at 4:29	history	edited	Erwin Brandstetter	CC BY-SA 3.0	explain why the cast works
Jan 7, 2016 at 16:52	vote	accept	Clodoaldo
Jan 7, 2016 at 14:22	history	edited	Erwin Brandstetter	CC BY-SA 3.0	added 41 characters in body
Jan 7, 2016 at 14:04	comment	added	Erwin Brandstetter		@dezso: For most simple cases, yes. The question demonstrates a case where `IN(...)` cannot be translated to `= ANY('{...}')`.
Jan 7, 2016 at 13:57	comment	added	András Váczi		A minor addition: while a short `IN(...)` list may be translated (by the planner) into an `... OR ...` expression in the above case, it is usually just translated into `ANY('{...}')`, that is, using an array. So, in most cases, `IN` with a list of values and `ANY` with an array are the same thing.
Jan 7, 2016 at 13:57	history	edited	Erwin Brandstetter	CC BY-SA 3.0	edited body
Jan 7, 2016 at 13:49	history	edited	Erwin Brandstetter	CC BY-SA 3.0	add more, be as clear as possible
Jan 7, 2016 at 13:33	history	edited	Erwin Brandstetter	CC BY-SA 3.0	added 1387 characters in body
Jan 7, 2016 at 13:23	history	answered	Erwin Brandstetter	CC BY-SA 3.0