Re: [GENERAL] failed to find conversion function from "unknown" to ...

2005-06-21 Thread Ilja Golshtein
Hi! >select 1 where 'vasya' = (select 'vasya') >produces >ERROR: failed to find conversion function from "unknown" to text I managed to find two similar messages in GENERAL archive. In first message http://archives.postgresql.org/pgsql-general/2004-10/msg01368.php Tom Lane says explicit cast i

[GENERAL] failed to find conversion function from "unknown" to ...

2005-06-20 Thread Ilja Golshtein
Hello! This query select 1 where 'vasya' = (select 'vasya') produces ERROR: failed to find conversion function from "unknown" to text in my 8.0.0. If I explicitly cast second 'vasya' to text, it is Ok. Everything is fine if data comes from database, IOW type is known. Is what I am describ