PostgreSQL: CAST function

Question

I have a problem with a CAST function in PostgreSQL. In particular, I have to convert an arithmetic operation (a percentage calcul), where the operands are int type, in a bigint type. But when I type this command:

CAST(("Language".percentage * "Population".population) AS bigint) /100.0 AS pop_speak_lang

The outcome is:

ERROR: integer out of limits

If someone could help me I would really appreciate!

Tomasz Jakub Rup · Accepted Answer · 2015-11-17 16:47:41Z

1

You don't need cast

"Language".percentage / 100.0 * "Population".population AS pop_speak_lang

answered Nov 17, 2015 at 16:47

Tomasz Jakub Rup

10.7k7 gold badges52 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL: CAST function

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related