Search Postgresql Archives

Syntax question - compound value comparisons

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I can do this:

SELECT * FROM library_items WHERE (li_lib, li_item) = (11080,123063);
 li_lib | li_item
--------+---------
  11080 |  123063

But not this:

SELECT * FROM library_items WHERE (li_lib, li_item) IN ( (11080,123063), 
(11081, 122250) );
ERROR:  syntax error at or near "11080" at character 59

Is this just a parser weakness (in which case, can I ask someone in core for a 
TODO - tia) or is there some subtle reason why it isn't supposed to work.

-- 
  Richard Huxton
  Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux