| From: | Stephen Froehlich <s(dot)froehlich(at)cablelabs(dot)com> |
|---|---|
| To: | Chamath Sajeewa <csgsajeewa(at)gmail(dot)com>, "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org> |
| Subject: | RE: Pgsql error in coalesce |
| Date: | 2020-07-27 17:05:46 |
| Message-ID: | CH2PR06MB64706ABCFCB27BAACBC50BD8E5720@CH2PR06MB6470.namprd06.prod.outlook.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
What do you get with the following two type castings:
SELECT coalesce(column_name::integer, 255); ?
SELECT coalesce(column_name, ‘255’::text)::integer; ?
“integer” might actually be “smallint” if you’re only going to 255.
--Stephen
From: Chamath Sajeewa <csgsajeewa(at)gmail(dot)com>
Sent: Monday, July 27, 2020 10:51
To: pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: Pgsql error in coalesce
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 | Date | Subject | |
|---|---|---|---|
| Next Message | Chamath Sajeewa | 2020-07-27 17:15:02 | Re: Pgsql error in coalesce |
| Previous Message | Chamath Sajeewa | 2020-07-27 16:51:17 | Pgsql error in coalesce |