diff options
author | Bruce Momjian <bruce@momjian.us> | 2000-08-29 04:41:48 +0000 |
---|---|---|
committer | Bruce Momjian <bruce@momjian.us> | 2000-08-29 04:41:48 +0000 |
commit | dffd8cac3dd8fb99ed4299bf2ef7eddba6eeaba2 (patch) | |
tree | de1078c4af77f5d1f5db078d86874145e2d8cb97 /doc/src | |
parent | d4f626507ca56bf3e1a8adeea7f158535ddb0220 (diff) |
* to_char:
- full support for IW (ISO week) and vice versa conversion for IW too
(the to_char 'week' support is now complete and I hope correct).
Thomas, I use for IW code from timestamp.c, for this I create separate
function date2isoweek() from original 'case DTK_WEEK:' code in the
timestamp_part(). I mean will better use one code for same feature in
date_part() and in to_char(). The isoweek2date() is added to timestamp.c
too. Right?
IMHO in 7.1 will all to_char's features complete. It is cca 41 templates
for date/time and cca 21 for numbers.
* to_ascii:
- gcc, is it correct now? :-)
In the patch is documentation for to_char's IW and for to_ascii().
Karel
Diffstat (limited to 'doc/src')
-rw-r--r-- | doc/src/sgml/func.sgml | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index aa7e2b09898..9f8fdd89324 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -356,6 +356,12 @@ </thead> <tbody> <row> + <entry>to_ascii(text [,name|int])</entry> + <entry>text</entry> + <entry>convert text from multibyte encoding to ASCII</entry> + <entry>to_ascii('Karel')</entry> + </row> + <row> <entry>char(text)</entry> <entry>char</entry> <entry>convert text to char type</entry> @@ -447,6 +453,9 @@ <para> Most functions explicitly defined for text will work for char() and varchar() arguments. </para> + <para> + The to_ascii() support conversion from LATIN1, LATIN2, WIN1250 (CP1250) only. + </para> </sect1> <sect1> @@ -804,6 +813,10 @@ <entry>week number of year (1-53) where first week start on the first day of the year</entry> </row> <row> + <entry>IW</entry> + <entry>ISO week number of year</entry> + </row> + <row> <entry>CC</entry> <entry>century (2 digits)</entry> </row> |