Subject | Re: [firebird-support] COMPUTED BY |
---|---|
Author | Ivan Prenosil |
Post date | 2006-04-13T13:47:56Z |
> 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/