problem with to_char

Поиск
Список
Период
Сортировка
Искать
От
Carsten Grewe
Тема
problem with to_char
Дата
Msg-id
200201290845.g0T8j9l91001@postgresql.org
Список
Дерево обсуждения
Re: problem with to_char Thomas Lockhart <lockhart@fourpalms.org>
Re: problem with to_char Karel Zak <zakkr@zf.jcu.cz>
Hi!

I think I have not understood some elementary things of the to_char function 
in pgsql7.1.2. I only get back a mask instead of a formatted string.

I tried the following in psql:
SPS=> select to_char(45145, '9.999,99');
  to_char
-----------
  #.###,##
(1 row)

I also tried a "normal" query in the form:
	select col1,col2,to_char(col3, '9.999,99') from test;
with col3 as numeric values. I also only get a mask in the 3rd col.

What am I doing wrongly?

Kind regards,
Carsten Grewe
В списке pgsql-general по дате отправления
От: Dmitry Alyabyev
Дата:
От: Karl DeBisschop
Дата:
Сообщение: Re: Pg_dump options
FAQ