Re: [GENERAL] Implicit typecasting to numeric in psql

2017-05-02 Thread Tom Lane
Payal Singh writes: > I have a table with an integer column 'userid'. But I am not seeing an out > of range error when trying to get an id larger than possible in integer: > db=# explain select * from users where userid = > 21474836472871287898765456789::numeric; Cross-type comparisons are legal

[GENERAL] Implicit typecasting to numeric in psql

2017-05-02 Thread Payal Singh
Hi, I have a table with an integer column 'userid'. But I am not seeing an out of range error when trying to get an id larger than possible in integer: db=# explain select * from users where userid = 21474836472871287898765456789::numeric; QUERY PLAN --