Subject Re: [firebird-support] COMPUTED BY
Author Ivan Prenosil
> It is possible use a SELECT in a COMPUTED BY? What is the syntax?

Syntax for COMPUTED BY is

COMPUTED BY (<expression>)

If you need SELECT to behave like expression (part of expression) it must be
enclosed in parenthesis, i.e.

(SELECT SUM(ABC) FROM TAB WHERE ...)


So, to combine these two you need two pairs of parenthesis, e.g.

COMPUTED BY ( (SELECT SUM(ABC) FROM TAB WHERE ...) )

Ivan
http://www.volny.cz/iprenosil/interbase/