On 20 Feb 2013, at 12:17pm, Marcin Kałuża <marcin.kal...@megiteam.pl> wrote:
> sqlite> select * from t where v = (select v from t); > 1 There is no definition for what this means under SQL. Any SQL implementation might consider it an error, or always evaluate (item = list) as false, or do anything else. I don't think you can point to either postgres or SQLite as definitely being buggy on this one. By the way it is an error to use postgres as a model of correct behaviour about SQL. It has just as many weird characteristics as the other implementations of SQL I've seen. Since SQL is not procedurally specified there are many muddy areas in its definition. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
