as attache of this mail is patch (to the main tree) with to_char's
Bruce Momjian <bruce@momjian.us>
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/
Files
| Path | Change | +/− |
|---|---|---|
| contrib/dateformat/Makefile | deleted | +0 −71 |
| contrib/dateformat/test/Makefile | deleted | +0 −25 |
| contrib/dateformat/test/rand_datetime.c | deleted | +0 −71 |
| contrib/dateformat/test/README | deleted | +0 −33 |
| contrib/dateformat/test/regress.sql | deleted | +0 −58 |
| contrib/dateformat/to-from_char.c | deleted | +0 −1382 |
| contrib/dateformat/to-from_char.doc | deleted | +0 −183 |
| contrib/dateformat/to-from_char.h | deleted | +0 −18 |
| contrib/dateformat/to-from_char.sql.in | deleted | +0 −29 |
| contrib/README | modified | +0 −4 |
| doc/src/sgml/func.sgml | modified | +541 −0 |
| src/backend/utils/adt/formatting.c | added | +3157 −0 |
| src/backend/utils/adt/Makefile | modified | +2 −2 |
| src/include/catalog/pg_proc.h | modified | +25 −1 |
| src/include/utils/formatting.h | added | +31 −0 |