Re: [GENERAL] Set Membership operator -- test group membership

2005-06-14 Thread Sophie Yang
4-6700 Fax: 907-644-6780 igor ( dot ) katrayev ( at ) nprb ( dot ) org -Original Message- From: pgsql-general-owner ( at ) postgresql ( dot ) org [mailto:pgsql-general-owner ( at ) postgresql ( dot ) org] On Behalf Of Sophie Yang Sent: Tuesday, June 14, 2005 11:09 AM To: pgsql-general ( at )

[GENERAL] Set Membership operator -- test group membership

2005-06-14 Thread Sophie Yang
Say I have a table tbl1 with two columns: tbl1(a integer, b integer, c integer) I want to select the rows in which a and b are members of a list of integer pairs. The SQL in my mind is something like: select * from tbl1 where (a, b) in ((1, 20), (2, 30), (3, 50)); I know the SQL above does n