failed to find conversion function from "unknown" to ...
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 describing desired behavior?
Thanks.
--
Best regards
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 is requiered
in second message
http://archives.postgresql.org/pgsql-sql/2005-01/msg00058.php
Tom Lane says it is a problem in PG.
These messages are about different things (first is
about View and second is about Case), though I don't
see difference between this situations and
don't have clear picture where (and what is the reason
behind this) I should explicitly
cast literals to text or varchar and where it is not
required.
Is this problem of string literals only or some other
types are involved?
Thanks.
--
Best regards
Ilja Golshtein