Hello All,
For example we have table like this:

CREATE TABLE map (
  name text,
  x integer,
  y integer
);
CREATE INDEX map_xy ON map(x,y);

How to query this table with "IN" keyword?
Query like this, doesn't work:

SELECT * FROM map WHERE (x,y) IN ((1,1),(1,2),(1,3));

-- 
Alexander Batyrshin aka bash
bash = Biomechanica Artificial Sabotage Humanoid
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to