alq666 · August 20, 2013 15:09
diff --git a/better-query-blog.sql b/better-query-blog.sql
 SELECT c.key,
       c.x_key,
       c.tags,
       x.name
 FROM context c
 JOIN x
   ON c.x_key = x.key
 WHERE c.key = ANY (VALUES (15368196), -- 11,000 other keys --)
  AND c.x_key = 1
  AND c.tags @> ARRAY[E'blah'];
	SELECT c.key,
	c.x_key,
	c.tags,
	x.name
	FROM context c
	JOIN x
	ON c.x_key = x.key
	WHERE c.key = ANY (VALUES (15368196), -- 11,000 other keys --)
	AND c.x_key = 1
	AND c.tags @> ARRAY[E'blah'];