Re: Putting an aggregate value in an UPDATE statement...

On Tuesday 1. June 2010 23.34.39 Tom Lane wrote:
> Well, the main point is that the possible ambiguity means that SQL has
> mandated you put parentheses around any sub-select.  However, if you're
> claiming there is no possible ambiguity inside a function call, compare:
>
>     select myfunc((select integer_col from foo where bar = 5+4))
>     select myfunc((select integer_col from foo where bar = 5)+4)
>
> These mean different things, and you couldn't tell 'em apart without
> the inner parentheses.

Right, I get it. Thanks for the explanation.

regards,
--
Leif Biberg Kristensen
http://solumslekt.org/blog/