Re: Added Having Clause

Applied.

This adds HAVING to the system, and is our first contribution from
Stefan, who is doing his thesis on adding ANSI features to PostgreSQL.
(Stefan, correct me if I am wrong on this.) He plans to finish by June.

Hi!

I started adding the Having Clause and it works quite fine for
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!!):

It is encoded using uuencode and called:
postgresql-6.3.tar.gz_to_having.diff.gz.uu

If your original 6.3 source tree is in:
tmp/postgresql-6.3/
perform the following steps to apply the patch:

$ cd tmp/
$ uudecode postgresql-6.3.tar.gz_to_having.diff.gz.uu
$ gunzip postgresql-6.3.tar.gz_to_having.diff.gz
$ patch < postgresql-6.3.tar.gz_to_having.diff

Hopefully you will see only "Hunk succeeded..." messages :-)

Regards

Stefan

-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)