1. 28 May, 2003 3 commits
    • 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
    • Bruce Momjian's avatar
      Add to thread discussion. · e5f19598
      Bruce Momjian authored
      e5f19598
    • Bruce Momjian's avatar
      Add info about selecting a random row. · a2b498c2
      Bruce Momjian authored
      a2b498c2
  2. 27 May, 2003 6 commits
  3. 26 May, 2003 9 commits
    • Tom Lane's avatar
      Adjust error-handling logic in libpq. For the first time, libpq copes · 5493ecc3
      Tom Lane authored
      sanely with running out of memory for a query result.
      5493ecc3
    • Bruce Momjian's avatar
      90903069
    • Tom Lane's avatar
      Fix misstatement in release-notes item. · 6923ea2b
      Tom Lane authored
      6923ea2b
    • Bruce Momjian's avatar
      Update: · 4b864e7c
      Bruce Momjian authored
      < * Add now("transaction|statement|clock") functionality
      > * Add transaction_timestamp(), statement_timestamp(), clock_timestamp() functionality
      4b864e7c
    • Tom Lane's avatar
      Make sure printtup() always sends the number of columns previously · 8c43300c
      Tom Lane authored
      advertised in RowDescription message.  Depending on the physical tuple's
      column count is not really correct, since according to heap_getattr()
      conventions the tuple may be short some columns, which will automatically
      get read as nulls.  Problem has been latent since forever, but was only
      exposed by recent change to skip a projection step in SELECT * FROM...
      8c43300c
    • Bruce Momjian's avatar
      Add documentation to 'createuser' that ALTER USER must be used to add or · b71a4899
      Bruce Momjian authored
      modify passwords, per user confusion report.
      
      Also clean up wording that command line utils need database access.
      b71a4899
    • Bruce Momjian's avatar
      Add: · ab64881f
      Bruce Momjian authored
      > * Allow UPDATE to use SET col = DEFAULT
      ab64881f
    • Bruce Momjian's avatar
      bb9f84aa
    • 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
  4. 25 May, 2003 4 commits
    • Peter Eisentraut's avatar
      Information schema improvements · 297c1658
      Peter Eisentraut authored
      297c1658
    • Bruce Momjian's avatar
      310049a1
    • Bruce Momjian's avatar
      Move item: · 8facf2df
      Bruce Momjian authored
      < * Update clients to use data types, typmod, schema.table.column names of
      <   result sets using new query protocol
      453a452,453
      > 	o Update clients to use data types, typmod, schema.table.column names of
      > 	  result sets using new query protocol
      8facf2df
    • Bruce Momjian's avatar
      Update: · 66f6bbb4
      Bruce Momjian authored
      < * Allow clients to get data types, typmod, schema.table.column names from
      <   result sets, either via the backend protocol or a new QUERYINFO command
      
      to:
      
      > * Update clients to use data types, typmod, schema.table.column names of
      >   result sets using new query protocol
      66f6bbb4
  5. 24 May, 2003 6 commits
  6. 23 May, 2003 6 commits
  7. 22 May, 2003 6 commits