1. 30 1月, 2000 2 次提交
  2. 29 1月, 2000 3 次提交
  3. 28 1月, 2000 6 次提交
    • B
      Update TODO list. · 3f6ff329
      Bruce Momjian 提交于
      3f6ff329
    • B
      Update TODO list. · a85b67d0
      Bruce Momjian 提交于
      a85b67d0
    • B
      Update TODO list. · 552bd964
      Bruce Momjian 提交于
      552bd964
    • T
      Apply the heuristic proposed by Taral (see pgsql-general archives for · 003dd965
      Tom Lane 提交于
      2-Oct-98 or TODO.detail/cnfify) to decide whether we want to reduce
      WHERE clause to CNF form, DNF form, or neither.  This is a HUGE win.
      The heuristic conditions could probably still use a little tweaking to
      make sure we don't pick CNF when DNF would be better, or vice versa,
      but the risk of exponential explosion in cnfify() is gone.  I was able
      to run ten-thousand-AND-subclause queries through the planner in a
      reasonable amount of time.
      003dd965
    • M
      *** empty log message *** · b53955f3
      Michael Meskes 提交于
      b53955f3
    • T
      Redesign DISTINCT ON as discussed in pgsql-sql 1/25/00: syntax is now · dd979f66
      Tom Lane 提交于
      SELECT DISTINCT ON (expr [, expr ...]) targetlist ...
      and there is a check to make sure that the user didn't specify an ORDER BY
      that's incompatible with the DISTINCT operation.
      Reimplement nodeUnique and nodeGroup to use the proper datatype-specific
      equality function for each column being compared --- they used to do
      bitwise comparisons or convert the data to text strings and strcmp().
      (To add insult to injury, they'd look up the conversion functions once
      for each tuple...)  Parse/plan representation of DISTINCT is now a list
      of SortClause nodes.
      initdb forced by querytree change...
      dd979f66
  4. 27 1月, 2000 3 次提交
  5. 26 1月, 2000 3 次提交
    • B
      Add include for float.h. · 02d83c44
      Bruce Momjian 提交于
      02d83c44
    • B
      Add: · 5c25d602
      Bruce Momjian 提交于
        * Portions Copyright (c) 1996-2000, PostgreSQL, Inc
      
      to all files copyright Regents of Berkeley.  Man, that's a lot of files.
      5c25d602
    • B
      as attache of this mail is patch (to the main tree) with to_char's · b866d2e2
      Bruce Momjian 提交于
      family functions. Contain:
      
        conversion from a datetype to formatted text:
      
      	to_char( datetime, 	text)
      	to_char( timestamp,	text)
      	to_char( int4,		text)
      	to_char( int8,		text)
      	to_char( float4,	text)
      	to_char( float8,	text)
      	to_char( numeric,	text)
      
        vice versa:
      
      	to_date		( text, text)
      	to_datetime	( text, text)
      	to_timestamp	( text, text)
      	to_number	( text, text)	   (convert to numeric)
      
      
        PostgreSQL to_char is very compatible with Oracle's to_char(), but not
      total exactly (now). Small differentions are in number formating. It will
      fix in next to_char() version.
      
      
      ! If will this patch aplly to the main tree, must be delete the current
        to_char version in contrib (directory "dateformat" and note in contrib's
        README), this patch not erase it (sorry Bruce).
      
      
      
      The patch patching files:
      
      	doc/src/sgml/func.sgml
                           ^^^^^^^^
         Hmm, I'm not sure if my English... :( Check it anyone (volunteer)?
      
         Thomas, it is right? SGML is not my primary lang  and compile
         the current PG docs tree is very happy job (hard variables setting in
         docs/sgml/Makefile --> HSTYLE= /home/users/t/thomas/....  :-)
      
         What add any definition to global configure.in and set Makefiles in docs
         tree via ./configure?
      
      	src/backend/utils/adt/Makefile
      	src/backend/utils/adt/formatting.c
      	src/include/catalog/pg_proc.h
      	src/include/utils/formatting.h
      Karel Zak <zakkr@zf.jcu.cz>              http://home.zf.jcu.cz/~zakkr/
      b866d2e2
  6. 25 1月, 2000 6 次提交
  7. 24 1月, 2000 4 次提交
  8. 23 1月, 2000 11 次提交
  9. 22 1月, 2000 2 次提交