1. 10 9月, 2006 1 次提交
    • T
      Rename contains/contained-by operators to @> and <@, per discussion that · ba920e1c
      Tom Lane 提交于
      agreed these symbols are less easily confused.  I made new pg_operator
      entries (with new OIDs) for the old names, so as to provide backward
      compatibility while making it pretty easy to remove the old names in
      some future release cycle.  This commit only touches the core datatypes,
      contrib will be fixed separately.
      ba920e1c
  2. 25 8月, 2006 1 次提交
  3. 12 7月, 2006 1 次提交
  4. 02 5月, 2006 1 次提交
  5. 08 11月, 2005 1 次提交
  6. 02 7月, 2005 2 次提交
  7. 12 4月, 2005 1 次提交
  8. 22 11月, 2003 1 次提交
    • T
      COMMENT ON casts, conversions, languages, operator classes, and · 42ce74bf
      Tom Lane 提交于
      large objects.  Dump all these in pg_dump; also add code to pg_dump
      user-defined conversions.  Make psql's large object code rely on
      the backend for inserting/deleting LOB comments, instead of trying to
      hack pg_description directly.  Documentation and regression tests added.
      
      Christopher Kings-Lynne, code reviewed by Tom
      42ce74bf
  9. 13 11月, 2003 1 次提交
    • T
      Cross-data-type comparisons are now indexable by btrees, pursuant to my · fa5c8a05
      Tom Lane 提交于
      pghackers proposal of 8-Nov.  All the existing cross-type comparison
      operators (int2/int4/int8 and float4/float8) have appropriate support.
      The original proposal of storing the right-hand-side datatype as part of
      the primary key for pg_amop and pg_amproc got modified a bit in the event;
      it is easier to store zero as the 'default' case and only store a nonzero
      when the operator is actually cross-type.  Along the way, remove the
      long-since-defunct bigbox_ops operator class.
      fa5c8a05
  10. 25 9月, 2003 1 次提交
  11. 22 7月, 2003 1 次提交
  12. 29 5月, 2003 2 次提交
    • T
      d998fac9
    • T
      Replace functional-index facility with expressional indexes. Any column · fc8d970c
      Tom Lane 提交于
      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
  13. 28 8月, 2001 1 次提交
  14. 16 7月, 2001 1 次提交
  15. 17 2月, 2000 1 次提交
    • T
      Finish repairing 6.5's problems with r-tree indexes: create appropriate · 598ea2c3
      Tom Lane 提交于
      selectivity functions and make the r-tree operators use them.  The
      estimation functions themselves are just stubs, unfortunately, but
      perhaps someday someone will make them compute realistic estimates.
      Change pg_am so that the optimizer can reliably tell the difference
      between ordered and unordered indexes --- before it would think that
      an r-tree index can be scanned in '<<' order, which is not right AFAIK.
      Repair broken negator links for network_sup and related ops.
      Initdb forced.  This might be my last initdb force for 7.0 ... hope so
      anyway ...
      598ea2c3
  16. 06 1月, 2000 1 次提交
  17. 26 4月, 1998 1 次提交
  18. 08 4月, 1998 1 次提交
  19. 31 3月, 1998 1 次提交
    • B
      The following uuencoded, gzip'd file will ... · 57b59664
      Bruce Momjian 提交于
      1. Remove the char2, char4, char8 and char16 types from postgresql
      2. Change references of char16 to name in the regression tests.
      3. Rename the char16.sql regression test to name.sql.  4. Modify
      the regression test scripts and outputs to match up.
      
      Might require new regression.{SYSTEM} files...
      
      Darren King
      57b59664
  20. 06 4月, 1997 1 次提交