Re: [GENERAL] float to int

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 ) expressi

Re: [GENERAL] 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

[GENERAL] float to int

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. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/f

[GENERAL] Float Infinity

Hi All, I just want to ask shouldn't substraction from infinity returns infinity in float just like in timestamp? This is for float: a=# SELECT version(); version ---

[GENERAL] Float

I'm want to create a table with data types float or doubles. How can I declare them ? Create table rrr ( tip1 (float)???, ); Thanks