Re: [HACKERS] ERROR: failed to find conversion function from "unknown" to text - Mailing list pgsql-general

From Tom Lane
Subject Re: [HACKERS] ERROR: failed to find conversion function from "unknown" to text
Date
Msg-id 8183.1231249686@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] ERROR: failed to find conversion function from "unknown" to text  ("Gurjeet Singh" <singh.gurjeet@gmail.com>)
Responses Is there a way to do an exact-match search on this list?  ("Rob Richardson" <Rob.Richardson@rad-con.com>)
Re: [HACKERS] ERROR: failed to find conversion function from "unknown" to text  ("Gurjeet Singh" <singh.gurjeet@gmail.com>)
List pgsql-general
"Gurjeet Singh" <singh.gurjeet@gmail.com> writes:
>> This is a horrendously bad idea; it will bite your *ss sooner or later,
>> probably sooner.

> Can you please let us know how this would be problematic?

The point is that it's going to have unknown, untested effects on the
default coercion rules, possibly leading to silent changes in the
behavior of queries that used to work.  If you'd rather retest every one
of your other queries than fix this one, then go ahead.

            regards, tom lane

pgsql-general by date:

Previous
From: "Gurjeet Singh"
Date:
Subject: Re: [HACKERS] ERROR: failed to find conversion function from "unknown" to text
Next
From: "Rob Richardson"
Date:
Subject: Is there a way to do an exact-match search on this list?