Re: [SQL] subquery, except and view

wieck@debis.com (Jan Wieck) writes:
>> test :>select client.num_clt, client.name from client, commamount where
>> test :>(client.num_clt = commamount.num_clt) and
>> test :>(3 > howmuch);
>> 
>> This seems to do the job perfectly. Notice the value preceeding the
>> column name in the comparison. Seems nescesary ...

>     Is  definitely  necessary,  because 'howmuch' is an aggregate
>     column  and  the  rewriter  can  only  put  that   into   the
>     qualification  if  the  aggreate  is on the right side of the
>     comparision.

BTW, this restriction is no longer true in current sources, since
single-result sub-SELECTs can now appear anywhere in an expression...
        regards, tom lane