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/faq