SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-08-2008, 09:30 PM
| ||||
| ||||
 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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings      |
|
04-08-2008, 09:31 PM
| ||||
| ||||
| Re: failed to find conversion function from "unknown" to ... 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...0/msg01368.php Tom Lane says explicit cast is requiered in second message http://archives.postgresql.org/pgsql...1/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 |
Linear Mode
