Home > mailing lists

Pgsql error in coalesce - Mailing list pgsql-novice

From	Chamath Sajeewa
Subject	Pgsql error in coalesce
Date	July 27, 2020 16:51:17
Msg-id	CACpofejQ12OBATx9Mi1YB24bj4Y4Ey6gq0fmncPp-b3hAyRtyQ@mail.gmail.com Whole thread Raw
Responses	RE: Pgsql error in coalesce RE: Pgsql error in coalesce Re: Pgsql error in coalesce RE: [EXTERNAL] Pgsql error in coalesce
List	pgsql-novice

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".

Any idea?

Thank You!!

From: Chamath Sajeewa
Date: 27 July 2020, 06:55:25
Subject: Re: Not null constraint in postgre

From: Stephen Froehlich
Date: 27 July 2020, 17:05:46
Subject: RE: Pgsql error in coalesce