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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
