]> granicus.if.org Git - postgresql/commit
as attache of this mail is patch (to the main tree) with to_char's
authorBruce Momjian <bruce@momjian.us>
Tue, 25 Jan 2000 23:53:56 +0000 (23:53 +0000)
committerBruce Momjian <bruce@momjian.us>
Tue, 25 Jan 2000 23:53:56 +0000 (23:53 +0000)
commitb866d2e2d79416f8497e4dffa7e800298d018f6c
treeb633b1415e4b916aaff71d86dc8cee4dba0258e9
parent90aaad06cf25753e10717ac7eb727cd65d8d5726
 as attache of this mail is patch (to the main tree) with to_char's
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/
15 files changed:
contrib/README
contrib/dateformat/Makefile [deleted file]
contrib/dateformat/test/Makefile [deleted file]
contrib/dateformat/test/README [deleted file]
contrib/dateformat/test/rand_datetime.c [deleted file]
contrib/dateformat/test/regress.sql [deleted file]
contrib/dateformat/to-from_char.c [deleted file]
contrib/dateformat/to-from_char.doc [deleted file]
contrib/dateformat/to-from_char.h [deleted file]
contrib/dateformat/to-from_char.sql.in [deleted file]
doc/src/sgml/func.sgml
src/backend/utils/adt/Makefile
src/backend/utils/adt/formatting.c [new file with mode: 0644]
src/include/catalog/pg_proc.h
src/include/utils/formatting.h [new file with mode: 0644]