1. 16 Oct, 2003 2 commits
  2. 29 Sep, 2003 1 commit
  3. 20 Sep, 2003 1 commit
  4. 11 Sep, 2003 1 commit
  5. 27 Aug, 2003 1 commit
  6. 17 Aug, 2003 1 commit
  7. 31 Jul, 2003 1 commit
  8. 29 Jul, 2003 1 commit
    • Tom Lane's avatar
      Apply (a somewhat revised version of) Greg Mullane's patch to eliminate · 9c2a7c22
      Tom Lane authored
      heuristic determination of day vs month in date/time input.  Add the
      ability to specify that input is interpreted as yy-mm-dd order (which
      formerly worked, but only for yy greater than 31).  DateStyle's input
      component now has the preferred spellings DMY, MDY, or YMD; the older
      keywords European and US are now aliases for the first two of these.
      Per recent discussions on pgsql-general.
      9c2a7c22
  9. 25 Jul, 2003 1 commit
  10. 24 Jul, 2003 1 commit
  11. 23 Jul, 2003 2 commits
  12. 17 Jul, 2003 1 commit
  13. 15 Jul, 2003 1 commit
  14. 30 Jun, 2003 1 commit
  15. 28 Jun, 2003 1 commit
    • Tom Lane's avatar
      Update psql for some features of new FE/BE protocol. There is a · f9ebf369
      Tom Lane authored
      client-side AUTOCOMMIT mode now: '\set AUTOCOMMIT off' supports
      SQL-spec commit behavior.  Get rid of LO_TRANSACTION hack --- the
      LO operations just work now, using libpq's ability to track the
      transaction status.  Add a VERBOSE variable to control verboseness
      of error message display, and add a %T prompt-string code to show
      current transaction-block status.  Superuser state display in the
      prompt string correctly follows SET SESSION AUTHORIZATION commands.
      Control-C works to get out of COPY IN state.
      f9ebf369
  16. 19 Jun, 2003 1 commit
    • Tom Lane's avatar
      Disallow dollar sign in operator names, instead allow it as a non-first · 1bd22f55
      Tom Lane authored
      character in identifiers.  The first change eliminates the current need
      to put spaces around parameter references, as in "x<=$2".  The second
      change improves compatibility with Oracle and some other RDBMSes.  This
      was discussed and agreed to back in January, but did not get done.
      1bd22f55
  17. 17 Jun, 2003 1 commit
  18. 28 May, 2003 1 commit
    • Tom Lane's avatar
      Replace functional-index facility with expressional indexes. Any column · fc8d970c
      Tom Lane authored
      of an index can now be a computed expression instead of a simple variable.
      Restrictions on expressions are the same as for predicates (only immutable
      functions, no sub-selects).  This fixes problems recently introduced with
      inlining SQL functions, because the inlining transformation is applied to
      both expression trees so the planner can still match them up.  Along the
      way, improve efficiency of handling index predicates (both predicates and
      index expressions are now cached by the relcache) and fix 7.3 oversight
      that didn't record dependencies of predicate expressions.
      fc8d970c
  19. 26 May, 2003 2 commits
    • Tom Lane's avatar
      Fix misstatement in release-notes item. · 6923ea2b
      Tom Lane authored
      6923ea2b
    • Tom Lane's avatar
      Cause CHAR(n) to TEXT or VARCHAR conversion to automatically strip trailing · f45df8c0
      Tom Lane authored
      blanks, in hopes of reducing the surprise factor for newbies.  Remove
      redundant operators for VARCHAR (it depends wholly on TEXT operations now).
      Clean up resolution of ambiguous operators/functions to avoid surprising
      choices for domains: domains are treated as equivalent to their base types
      and binary-coercibility is no longer considered a preference item when
      choosing among multiple operators/functions.  IsBinaryCoercible now correctly
      reflects the notion that you need *only* relabel the type to get from type
      A to type B: that is, a domain is binary-coercible to its base type, but
      not vice versa.  Various marginal cleanup, including merging the essentially
      duplicate resolution code in parse_func.c and parse_oper.c.  Improve opr_sanity
      regression test to understand about binary compatibility (using pg_cast),
      and fix a couple of small errors in the catalogs revealed thereby.
      Restructure "special operator" handling to fetch operators via index opclasses
      rather than hardwiring assumptions about names (cleans up the pattern_ops
      stuff a little).
      f45df8c0
  20. 22 May, 2003 1 commit
  21. 15 May, 2003 1 commit
  22. 14 May, 2003 1 commit
  23. 21 Mar, 2003 1 commit
  24. 05 Feb, 2003 1 commit
  25. 02 Feb, 2003 2 commits
  26. 29 Jan, 2003 1 commit
  27. 25 Jan, 2003 1 commit
    • Tom Lane's avatar
      Allow the planner to collapse explicit inner JOINs together, rather than · 9f5f2124
      Tom Lane authored
      necessarily following the JOIN syntax to develop the query plan.  The old
      behavior is still available by setting GUC variable JOIN_COLLAPSE_LIMIT
      to 1.  Also create a GUC variable FROM_COLLAPSE_LIMIT to control the
      similar decision about when to collapse sub-SELECT lists into their parent
      lists.  (This behavior existed already, but the limit was always
      GEQO_THRESHOLD/2; now it's separately adjustable.)
      9f5f2124
  28. 23 Jan, 2003 1 commit
  29. 20 Jan, 2003 1 commit
    • Tom Lane's avatar
      IN clauses appearing at top level of WHERE can now be handled as joins. · bdfbfde1
      Tom Lane authored
      There are two implementation techniques: the executor understands a new
      JOIN_IN jointype, which emits at most one matching row per left-hand row,
      or the result of the IN's sub-select can be fed through a DISTINCT filter
      and then joined as an ordinary relation.
      Along the way, some minor code cleanup in the optimizer; notably, break
      out most of the jointree-rearrangement preprocessing in planner.c and
      put it in a new file prep/prepjointree.c.
      bdfbfde1
  30. 11 Jan, 2003 1 commit
  31. 10 Jan, 2003 1 commit
  32. 08 Jan, 2003 1 commit
  33. 06 Jan, 2003 1 commit
  34. 30 Dec, 2002 1 commit
  35. 20 Dec, 2002 1 commit
  36. 18 Dec, 2002 1 commit