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