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



Posted by Jose Velasquez at 1:24 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Labels

  • Angular (1)
  • Builder (1)
  • error TS2531 (1)
  • Form Builder (2)
  • hasError (1)
  • Lombok (1)
  • Maven (1)

Search This Blog

Blog Archive

  • ►  2022 (1)
    • ►  December (1)
  • ►  2021 (3)
    • ►  June (1)
    • ►  May (1)
    • ►  April (1)
  • ►  2019 (1)
    • ►  February (1)
  • ►  2018 (2)
    • ►  June (1)
    • ►  May (1)
  • ►  2017 (6)
    • ►  August (1)
    • ►  July (1)
    • ►  June (2)
    • ►  May (2)
  • ►  2016 (10)
    • ►  July (2)
    • ►  March (1)
    • ►  February (5)
    • ►  January (2)
  • ▼  2015 (38)
    • ►  December (4)
    • ►  November (9)
    • ►  October (1)
    • ►  August (4)
    • ►  July (9)
    • ►  June (3)
    • ►  May (6)
    • ▼  April (2)
      • Generate free documents from scribd
      • PostgreSQL: Cast character to int or float PostgreSQL
  • ►  2014 (12)
    • ►  November (1)
    • ►  October (3)
    • ►  September (4)
    • ►  August (4)
  • ►  2013 (2)
    • ►  September (1)
    • ►  May (1)
  • ►  2011 (4)
    • ►  January (4)
  • ►  2010 (2)
    • ►  December (1)
    • ►  October (1)

Total Pageviews

Simple theme. Powered by Blogger.