firebird-automations

Modified by: Sean Leyne (seanleyne) description: SFID: 1036767#⁠ Submitted By: alexkrav80 1\) intersect: Result of \(select \.\.\.\) intersect \(select \.\.\.\) should be intersection of results\. 2\) minus Result of \(select...

Modified by: @dyemanov summary: Add support for INTERSECT and MINUS/EXCEPT data set operators =\> Add support for INTERSECT and EXCEPT data set operators

Commented by: Lukas Eder (lukas.eder) A related issue to the missing INTERSECT and EXCEPT keywords is the fact that currently, Firebird SQL doesn't allow for nesting set operations using parentheses...

Commented by: Henner Kollmann (hkollmann) Are there any plans to support intersect in FB 3\.0 or FB 4\.0?

Commented by: @livius2 in my humble opinion this feature is useless \(maybe with ALL it have some function\)\. Only from marketing POV that FB have this sql spec supported\.\. I...

Commented by: Volker Rehn (vr2_s18) @Karol: while it is possible to get the same results by using join \(haven't checked ALL\), the point is semantics\. You might as well argue...

Commented by: Lukas Eder (lukas.eder) @Karol: INTERSECT can be used for null\-safe comparisons between tuples\. For instance EXISTS \(\(SELECT a, b, c FROM t1\) INTERSECT \(SELECT x, y, z FROM...

Modified by: @livius2 Attachment: COREXXX\.FDB \[ 13362 \]

Modified by: @livius2 description: WITH KWARTALY AS \(SELECT \* FROM KWARTAL KW WHERE KW\.CKWARTAL BETWEEN '2019\.I' AND '2019\.I'\), KWARTALY\_DATY AS \(SELECT MIN\(KW\.ZALICZAJ\_OD\) AS MIN\_ZALICZAJ\_OD , MAX\(KW\.ZALICZAJ\_DO\) AS MAX\_ZALICZAJ\_DO , MIN\(KW\.D\_OD\)...

Commented by: Sean Leyne (seanleyne) Reformatted SQL for readibility