Postgres Pro
Downloads
Home   >   mailing lists

weird error message - Mailing list pgsql-sql

From Michael Moore
Subject weird error message
Date
Msg-id CACpWLjMK8J2O_zjrhBgfYoYU=eO=+CNO7DE0BNM6YNTkbYV4Hw@mail.gmail.com
Whole thread Raw
Responses Re: weird error message  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-sql
Tree view
SELECT COALESCE(dt, i) FROM  (SELECT  null AS dt, null AS i) q;
gives
ERROR:  failed to find conversion function from unknown to text
********** Error **********

ERROR: failed to find conversion function from unknown to text
SQL state: XX000

So, I understand the datatype of 'null' is 'unknown', but what does 'text' have to do with it?

Mike

pgsql-sql by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Getting the queried result in the form of json structure
Next
From: Adrian Klaver
Date:
Subject: Re: weird error message