PostgreSQL To_char Integer to String

Recently used the To_char in PostgreSQL to convert numbers to strings, and now the example of the Generals network is collected as follows

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/42/6A/wKioL1PXWUrBdQSxAAQeY2_oZAM247.jpg "title=" to_ Char.png "alt=" Wkiol1pxwurbdqsxaaqey2_ozam247.jpg "/>

In addition to the above functions, TO_CHAR also has rounding function

Select To_char (3.005, ' 0.99 ')

Returns 3.01

Select To_char (3.003, ' 0.99 ')

The return is 3.00.

Okay, what's the problem? Direct gossip, a hyper-communication.

This article is from "Chole Blog Learning Progress" blog, please be sure to keep this source http://sucre.blog.51cto.com/1084905/1532324