Add Support for tuple in where clauses

[jordanmarr]

Add Support for tuple in where clauses

[JordanMarr]

That was it. Still getting used to DBeaver which tries a little too hard to be helpful sometimes.
I know SQL Server doesn't support tuples, but maybe some others do.
I suppose this could be implemented and it could be up to the user to know if tuples are not supported.
Or maybe it would be worth converting the tuples to AND queries for SQL Server.

[JordanMarr]

Is that valid in PostgreSQL? I tried this query using the SqlHydra.Npgsql test database but it gives a syntax error:

select e.*
from humanresources.employee e 
(jobtitle, maritalstatus) = ('Design Engineer', 'M')

However, this works:

select e.*
from humanresources.employee e 
where jobtitle = 'Design Engineer' and maritalstatus = 'M'

[Swoorup]

The first one is missing a where?

This should work

sample=# with t as (select 1 as f, 2 as s) select * from t where (t.f,t.s) = (1,2);
 f | s
---+---
 1 | 2
(1 row) 	

It does work with string too. It is especially handy working with comparing multiple operators i.e less than/greater than, since the expanded form is bit lengthy.