1. 09 Feb, 1999 2 commits
  2. 06 Feb, 1999 1 commit
  3. 04 Feb, 1999 2 commits
  4. 03 Feb, 1999 1 commit
  5. 24 Jan, 1999 1 commit
  6. 21 Jan, 1999 1 commit
  7. 18 Dec, 1998 1 commit
  8. 04 Dec, 1998 1 commit
  9. 01 Oct, 1998 1 commit
  10. 01 Sep, 1998 2 commits
  11. 25 Aug, 1998 1 commit
    • Marc G. Fournier's avatar
      · f62d1253
      Marc G. Fournier authored
      From: Massimo Dal Zotto <dz@cs.unitn.it>
      
      >       these patches define the UNLISTEN sql command. The code already
      >       existed but it was unknown to the parser. Now it can be used
      >       like the listen command.
      >       You must make clean and delete gram.c and parser.h before make.
      f62d1253
  12. 18 Aug, 1998 1 commit
    • Marc G. Fournier's avatar
      · 338c54cb
      Marc G. Fournier authored
      From: Jan Wieck <jwieck@debis.com>
      
      Hi,
      
          as  proposed here comes the first patch for the query rewrite
          system.
      
        <for details, see archive dated Mon, 17 Aug 1998>
      338c54cb
  13. 05 Aug, 1998 1 commit
    • Marc G. Fournier's avatar
      · a1627a1d
      Marc G. Fournier authored
      From: David Hartwig <daybee@bellatlantic.net>
      
      I have attached a patch to allow GROUP BY and/or ORDER BY function or
      expressions.  Note worthy items:
      
      1. The expression or function need not be in the target list.
      Example:
                  SELECT  name FROM foo GROUP BY lower(name);
      
      2.   Simplified the grammar to use expressions only.
      
      3.  Cleaned up earlier patch in this area to make use of existing
      utility functions.
      
      3.  Reduced some of the members in the SortGroupBy parse node.   The
      original data members were redundant with the new expression node.
      (MUST do a "make clean" now)
      
      4.  Added a new parse node "JoinUsing".   The JOIN USING clause was
      overloading this SortGroupBy structure.   With the afore mentioned
      reduction of members, the two clauses lost all their commonality.
      
      5.  A bug still exist where, if a function or expression is GROUPed BY,
      and an aggregate function does not include a attribute from the
      expression or function, the backend crashes.   (or something like
      that)   The bug pre-dates this patch.    Example:
      
          SELECT lower(a) AS lowcase, count(b) FROM foo GROUP BY lowcase;
                       *** BOOM  ***
      
          --Also when not in target list
          SELECT  count(b) FROM foo GROUP BY lower(a);
                      *** BOOM  AGAIN ***
      a1627a1d
  14. 18 Jul, 1998 1 commit
  15. 13 Feb, 1998 1 commit
  16. 17 Jan, 1998 1 commit
  17. 10 Jan, 1998 1 commit
  18. 09 Jan, 1998 1 commit
  19. 18 Dec, 1997 1 commit
  20. 04 Dec, 1997 2 commits
  21. 21 Nov, 1997 1 commit
  22. 28 Oct, 1997 1 commit
  23. 29 Sep, 1997 1 commit
  24. 08 Sep, 1997 2 commits
  25. 07 Sep, 1997 1 commit
  26. 01 Sep, 1997 1 commit
  27. 31 Aug, 1997 1 commit
  28. 22 May, 1997 1 commit
  29. 23 Apr, 1997 1 commit
    • Marc G. Fournier's avatar
      To: Thomas Lockhart <Thomas.G.Lockhart@jpl.nasa.gov> · 4b531912
      Marc G. Fournier authored
      Subject: Re: [PATCHES] SET DateStyle patches
      
      On Tue, 22 Apr 1997, Thomas Lockhart wrote:
      
      > Some more patches! These (try to) finish implementing SET variable TO value
      > for "DateStyle" (changed the name from simply "date" to be more descriptive).
      > This is based on code from Martin and Bruce (?), which was easy to modify.
      > The syntax is
      >
      > SET DateStyle TO 'iso'
      > SET DateStyle TO 'postgres'
      > SET DateStyle TO 'sql'
      > SET DateStyle TO 'european'
      > SET DateStyle TO 'noneuropean'
      > SET DateStyle TO 'us'         (same as "noneuropean")
      > SET DateStyle TO 'default'    (current same as "postgres,us")
      >
      > ("european" is just compared for the first 4 characters, and "noneuropean"
      > is compared for the first 7 to allow less typing).
      >
      > Multiple arguments are allowed, so SET datestyle TO 'sql,euro' is valid.
      >
      > My mods also try to implement "SHOW variable" and "RESET variable", but
      > that part just core dumps at the moment. I would guess that my errors
      > are obvious to someone who knows what they are doing with the parser stuff,
      > so if someone (Bruce and/or Martin??) could have it do the right thing
      > we will have a more complete set of what we need.
      >
      > Also, I would like to have a floating point precision global variable to
      > implement "SET precision TO 10" and perhaps "SET precision TO 10,2" for
      > float8 and float4, but I don't know how to do that for integer types rather
      > than strings. If someone is fixing the SHOW and RESET code, perhaps they can
      > add some hooks for me to do the floats while they are at it.
      >
      > I've left some remnants of variable structures in the source code which
      > I did not use in the interests of getting something working for v6.1.
      > We'll have time to clean things up for the next release...
      4b531912
  30. 02 Apr, 1997 2 commits
  31. 02 Mar, 1997 1 commit
  32. 17 Dec, 1996 1 commit
  33. 03 Nov, 1996 1 commit
  34. 31 Oct, 1996 1 commit