Sign up ×

I need to convert a value of Double Precision to Bigint with PostgreSQL. How can I do that?

I have tried with to_bigint(myvalue) but that function didn't exist.

share|improve this question

1 Answer 1

up vote 12 down vote accepted

There are two ways to typecast in Postgres:

You either do it the SQL standard way:

select cast(3.141593 as bigint);

or you could use the Postgres-specific cast operator: ::

select (3.141593 :: bigint);

You might also want to consider the various rounding functions.

share|improve this answer
+1 for linking to the manual –  a_horse_with_no_name Jun 22 '11 at 11:23
@eevar Just a note from the docs, the rounding functions return type is "same as input," so if the type is important, casts are required. –  shortstuffsushi Aug 19 at 21:34

Your Answer


