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.
There are two ways to typecast in Postgres:
You either do it the SQL standard way:
or you could use the Postgres-specific cast operator:
You might also want to consider the various rounding functions.