1. 30 Mar, 1998 1 commit
    • Bruce Momjian's avatar
      I started adding the Having Clause and it works quite fine for · c579ce0f
      Bruce Momjian authored
      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
  2. 26 Feb, 1998 1 commit
  3. 10 Feb, 1998 1 commit
  4. 06 Feb, 1998 1 commit
  5. 20 Jan, 1998 2 commits
  6. 19 Jan, 1998 1 commit
  7. 15 Jan, 1998 1 commit
  8. 11 Jan, 1998 1 commit
  9. 10 Jan, 1998 1 commit
  10. 09 Jan, 1998 1 commit
  11. 05 Jan, 1998 1 commit
  12. 29 Dec, 1997 3 commits
  13. 27 Dec, 1997 1 commit
  14. 24 Dec, 1997 1 commit
  15. 23 Dec, 1997 1 commit
  16. 16 Dec, 1997 1 commit
  17. 09 Dec, 1997 1 commit
  18. 04 Dec, 1997 1 commit
  19. 26 Nov, 1997 1 commit
  20. 25 Nov, 1997 1 commit
  21. 20 Nov, 1997 1 commit
  22. 30 Oct, 1997 1 commit
  23. 25 Oct, 1997 1 commit
  24. 16 Oct, 1997 1 commit
  25. 12 Oct, 1997 1 commit
  26. 18 Sep, 1997 2 commits
  27. 08 Sep, 1997 3 commits
  28. 07 Sep, 1997 1 commit
  29. 05 Sep, 1997 2 commits
  30. 01 Sep, 1997 1 commit
  31. 22 Aug, 1997 1 commit
  32. 19 Aug, 1997 1 commit
  33. 18 Aug, 1997 1 commit