In the first place, thanks a very great deal for all the feedback.
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.
> On Tuesday 1. June 2010 23.34.39 Tom Lane wrote:
>> Well, the main point is that the possible ambiguity means that SQL
>> mandated you put parentheses around any sub-select.
In response to
pgsql-novice by date
|Next:||From: Michael Diener||Date: 2010-06-02 14:23:20|
|Subject: sum multiple tables gives wrong answer?|
|Previous:||From: Michelle Konzack||Date: 2010-06-02 00:05:51|
|Subject: Re: Invitation to connect on LinkedIn|