Monday, April 20, 2015

PostgreSQL: Cast character to int or float PostgreSQL

CREATE TABLE example
(
  id NOT NULL,
  char_field character varying(10) NOT NULL
)


SELECT sum(char_field :: float) FROM example
SELECT sum(char_field :: int) FROM example