> Hi, > There is table with int4 column. When select query is executed as "select > coalesce(column_name, 255), query is failing with below error. > "COALESCE types text and integer cannot be mached".
I'd bet you're not querying the table you think you're querying ... What does "\d table" show? Also, please show the complete query, and SHOW search_path .