Re: reformatting floats ?
От | Andreas Kretschmer |
---|---|
Тема | Re: reformatting floats ? |
Дата | |
Msg-id | 20071206184544.GA1654@KanotixBox обсуждение исходный текст |
Ответ на | reformatting floats ? ("Gauthier, Dave" <dave.gauthier@intel.com>) |
Ответы |
Re: reformatting floats ?
|
Список | pgsql-general |
Gauthier, Dave <dave.gauthier@intel.com> schrieb: > > > Hi: > > if... > create table coords (id int, x float, y float); > then... > insert into coords (id,x,y) values (1,1.000,2.001) > and then... > select * from coords > i get... > 1,1,2.001 > i want... > 1.1.000,2.001 > while retaining the numeric nature of the x,y data (for math ops in other > operations). > > How can I reformat the float output (sort of like using %5.3f in good-ole C) CAST it to numeric ;-) test=# create table coords (id int, x float, y float); CREATE TABLE Time: 4.437 ms test=*# insert into coords (id,x,y) values (1,1.000,2.001); INSERT 0 1 Time: 4.831 ms test=*# select id, x::numeric(10,3), y::numeric(10,3) from coords; id | x | y ----+-------+------- 1 | 1.000 | 2.001 Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknow) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
В списке pgsql-general по дате отправления: