Distinct is not a function, so the parentheses are useless noise. it is the same difference as between
SELECT R.RDB$FIELD_ID, R.RDB$RELATION_NAME FROM RDB$RELATIONS R and SELECT (R.RDB$FIELD_ID), R.RDB$RELATION_NAME FROM RDB$RELATIONS R
[email protected] [firebird-support] Tue, 17 Mar 2015 14:46:38 -0700
Distinct is not a function, so the parentheses are useless noise. it is the same difference as between
SELECT R.RDB$FIELD_ID, R.RDB$RELATION_NAME FROM RDB$RELATIONS R and SELECT (R.RDB$FIELD_ID), R.RDB$RELATION_NAME FROM RDB$RELATIONS R