On Fri, 2002-11-08 at 18:10, Mark Tooker wrote:
> SQL> select empno from emp where ((firstname,lastname) IN
> 2 (('John','Doe'),('Joe','Blow')));
>
> EMPNO
> ----------
> 1234
Cool, I'll have to try that sometime. Didn't know you could make tuples
out of values like that.
> Can anyone tell me what syntax _will_ work in psql?
I think you need to use and/or to duplicate that.
select empno
from emp
where (firstname = 'John' and lastname = 'Doe')
or (firstname = 'Joe' and lastname = 'Blow');
Not as terse, but it works.
Scott
