Postgres Pro
Downloads
Home   >   mailing lists

Pgsql error in coalesce - Mailing list pgsql-novice

From Chamath Sajeewa
Subject Pgsql error in coalesce
Date
Msg-id CACpofejQ12OBATx9Mi1YB24bj4Y4Ey6gq0fmncPp-b3hAyRtyQ@mail.gmail.com
Whole thread Raw
Responses RE: Pgsql error in coalesce  (Stephen Froehlich <s.froehlich@cablelabs.com>)
RE: Pgsql error in coalesce  (David Raymond <David.Raymond@tomtom.com>)
Re: Pgsql error in coalesce  (Alvaro Herrera <alvherre@2ndquadrant.com>)
RE: [EXTERNAL] Pgsql error in coalesce  ("Vianello, Dan A" <Dan.Vianello@charter.com>)
List pgsql-novice
Tree view
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!!

pgsql-novice by date:

Previous
From: Chamath Sajeewa
Date:
Subject: Re: Not null constraint in postgre
Next
From: Stephen Froehlich
Date:
Subject: RE: Pgsql error in coalesce