firebird-automations

Commented by: Sean Leyne (seanleyne) Why would this syntax be "usefull"? \(I will leave the discussion of the "modern"ess \[Not\!\] of the syntax alone for the moment\) The only use...

Commented by: @dyemanov Sean, this syntax is absolutely standard\. And I believe DB2 is not the only DBMS supporting it\.

Commented by: Sean Leyne (seanleyne) FYI, the syntax is not documented in the official IBM DB2 documentation for the latest v9\.8 DB2 release \(\), so forgive me if I don't...

Commented by: Sean Leyne (seanleyne) A review of the MS SQL and PostgresSQL documentation also finds that the proposed syntax is not documented\.

Commented by: @dyemanov

Commented by: Sean Leyne (seanleyne) It would seem appropriate for the subject of this case/entry to be changed to read "Add support for ROW\(\) constructor/comparison syntax", since the ROW\(\) functionality...

Modified by: @dyemanov summary: Support DB2\-like short syntax for multiple A=v1 and B=v2 and \.\.\. predicates =\> Add support for row value constructors and comparison operations

Modified by: @asfernandes Link: This issue is related to [CORE2621](https://github.com/FirebirdSQL/firebird/issues?q=CORE2621+in%3Atitle) \[ [CORE2621](https://github.com/FirebirdSQL/firebird/issues?q=CORE2621+in%3Atitle) \]

Modified by: @dyemanov Version: 3\.0 Initial \[ 10301 \] =\>

Commented by: Ain Valtin (ain) Looks like a nice feature :\) Suggestion \- also support to restrict the record variable to have only listed fields, ie DECLARE VARIABLE RECORD\[\(field1, field2,...