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
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