• B
    I started adding the Having Clause and it works quite fine for · c579ce0f
    Bruce Momjian 提交于
    sequential scans! (I think it will also work with hash, index, etc
    but I did not check it out! I made some High level changes which
    should work for all access methods, but maybe I'm wrong. Please
    let me know.)
    
    Now it is possible to make queries like:
    
    select s.sname, max(p.pid), min(p.pid) from part p, supplier s
    where s.sid=p.sid group by s.sname having max(pid)=6 and min(pid)=1
    or avg(pid)=4;
    
    Having does not work yet for queries that contain a subselect
    statement in the Having clause, I'll try to fix this in the next
    days.
    
    If there are some bugs, please let me know, I'll start to read the
    mailinglists now!
    
    Now here is the patch against the original 6.3 version (no snapshot!!):
    
    Stefan
    c579ce0f
analyze.c 21.7 KB