Postgres Pro
Downloads
Home   >   mailing lists

Re: float to int - Mailing list pgsql-general

From Edoardo Panfili
Subject Re: float to int
Date
Msg-id 47386CF7.2060608@aspix.it
Whole thread Raw
In response to float to int  ("Charles.Hou" <ivan.hou@msa.hinet.net>)
Responses Re: float to int
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Ken Winter"
Date:
Subject: How to uninstall the geometry package?
Next
From: Martijn van Oosterhout
Date:
Subject: Re: PQexec(), what should I do for the "NULL in command" problem?