Add support for row value constructors and comparison operations [CORE3070] #3449
Description
Submitted by: Alexey Kuznetsov (kuaw26)
Is related to CORE2621
Votes: 2
It would be very useful if Firebird would support modern syntax for A=v1 AND B=v2 predicates as it implemented in DB2 (see Db2 cookbook p39 http://mysite.verizon.net/graeme_birchall/id1.html)
example: modern syntax
SELECT id, dept, job
FROM staff
WHERE (id,dept) = (30,28)
OR (id,years) = (90, 7)
OR (dept,job) = (38,'Mgr')
ORDER BY 1;
old syntax:
SELECT id, dept, job
FROM staff
WHERE (id = 30 AND dept = 28)
OR (id = 90 AND years = 7)
OR (dept = 38 AND job = 'Mgr')
ORDER BY 1;