public inbox for [email protected]
help / color / mirror / Atom feedFrom: David Raymond <[email protected]>
To: [email protected] <[email protected]>
Subject: RE: Pgsql error in coalesce
Date: Mon, 27 Jul 2020 17:33:09 +0000
Message-ID: <AM0PR07MB4036F9D49A4B59C955B79F6587720@AM0PR07MB4036.eurprd07.prod.outlook.com> (raw)
In-Reply-To: <CACpofejQ12OBATx9Mi1YB24bj4Y4Ey6gq0fmncPp-b3hAyRtyQ@mail.gmail.com>
References: <CACpofejQ12OBATx9Mi1YB24bj4Y4Ey6gq0fmncPp-b3hAyRtyQ@mail.gmail.com>
Something's definitely weird here.
You're sure it's an int4 column?
Are you using an unqualified table name in the FROM clause which your search_path might be re-directing to a different table with the same name in a different schema where column_name is text? Or to a temp table with the same name which would be first in the search path?
You didn't accidentally put single quotes instead of double quotes around column_name?
Trying to think of any other little oopsies that might be in play here.
From: Chamath Sajeewa <[email protected]>
Sent: Monday, July 27, 2020 12:51 PM
To: [email protected]
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!!
view thread (10+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: RE: Pgsql error in coalesce
In-Reply-To: <AM0PR07MB4036F9D49A4B59C955B79F6587720@AM0PR07MB4036.eurprd07.prod.outlook.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox