firebird-automations

Modified by: Sean Leyne (seanleyne) 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...

Commented by: Sean Leyne (seanleyne) Karol, There are some aspects of the SQL which I find "unexpected": 1\- The use of UNION when AND EXISTS could be used 2\- The...

Commented by: @livius2 This is good catch, but as you probably can guess, this is not hand written query\. It is generated and mixed together from few separated modules\. I...

Modified by: @dyemanov assignee: Dmitry Yemanov \[ dimitr \]

Commented by: @mrotteveel I think this might be something to add to ISQL, maybe as an extension to input\. It should not be part of the normal SQL dialect since...

Commented by: Ivan (patuljak) but "Load" function is nice and very helpfull\.

Commented by: Volker Rehn (vr2_s18) @Mark, external tables have a number of issues, but the fixed length format makes them unusable for just about anything, be it csv or an...

Modified by: Vladimir Arkhipov (arkinform) description: Example: CREATE UNIQUE INDEX orders\_number\_idx ON orders \(number\) WHERE number is not null Description from "A partial index is an index built over a...

Commented by: @ibaseru Have doubts about this feature since it was implemented in FoxPro\. I understand that it will be nice for the former FoxPro users, but\.\.\. Less space used...

Commented by: Ann Harrison (awharrison) Firebird differs from Postgres in a couple of ways that affect this request\. One is that Firebird indexes use prefix compression, so a duplicate index...