float to int

Charles.Hou ha scritto:

how can i get the int value using the sql language? like this,

"select cost from my_money_table " , the data type of cost is float.

take a look at
http://www.postgresql.org/docs/8.2/static/sql-expressions.html
CAST ( expression AS type )
expression::type

Edoardo

--
Jabber: edoardopa@talk.google.com
tel: 075 9142766

Edoardo Panfili wrote:

Charles.Hou ha scritto:

how can i get the int value using the sql language? like this,

"select cost from my_money_table " , the data type of cost is float.

take a look at
http://www.postgresql.org/docs/8.2/static/sql-expressions.html
CAST ( expression AS type )
expression::type

Incidentally, float is about the worst data type to represent monetary amounts
that one can choose.

--
Lew