"Taylor Basilio" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Jun 13, 2008, at 7:41 PM, Igor Tandetnik wrote: > >> "Taylor Basilio" <[EMAIL PROTECTED]> >> wrote in message >> news:[EMAIL PROTECTED] >>> Is there a way to do tuple comparisons in SQLite? Are there plans to >>> support it as "SELECT (1, 2) = (1, 2)" in the future? >> >> Why? Is there any DBMS that supports this syntax? > > MySQL, PostgreSQL
Are you sure? I can't find any such thing in MySQL nor ProstreSQL documentation. The closest I see is select ROW(1,2) = ROW(1, 2); http://www.postgresql.org/docs/8.3/interactive/functions-comparisons.html#ROW-WISE-COMPARISON >> What's wrong with >> SELECT 1=1 AND 2=2 ? > > That works, but sucks if you have something like: > > ( (1, 2), .... ) = ( (1, 2), ... ) I must admit I don't understand what this last line is supposed to mean. It doesn't resemble anything I've seen in any SQL dialect I'm familiar with. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
