reformatting floats ? - Mailing list pgsql-general

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)

Thanks !