In the first place, thanks a very great deal for all the feedback.
Much appreciated.
In the second, the UPDATE statement I used as an example was really a
kludge because I could not figure out how to place the same SELECT
COUNT(*) expression into an INSERT statement. Turns out that by
enclosing _it_ in parentheses, everything is cool. Superb.
John
> 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.