TI Logbook
Java, Angular, Eclipse, PostgreSQL, SQL, Tips....
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
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment