В сообщении от Friday 13 June 2008 16:26:01 Igor Tandetnik написал(а): > "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#R >OW-WISE-COMPARISON
It's more shortly: where (a,b,c,d,e)=(1,2,3,4,5) then where a=1 and b=2 and c=3 and d=4 and e=5 and postgres lets it: $ psql template1 -U postgres -h localhost Welcome to psql 8.3.1, the PostgreSQL interactive terminal. template1=# create table test (a int,b int,c int,d int,e int); CREATE TABLE template1=# select * from test where (a,b,c,d,e)=(1,2,3,4,5); a | b | c | d | e ---+---+---+---+--- (0 rows) _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
