• Bruce Momjian's avatar
    as attache of this mail is patch (to the main tree) with to_char's · b866d2e2
    Bruce Momjian authored
    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
func.sgml 36.3 KB