Postgres Pro
Downloads
Home   >   mailing lists

failed to find conversion function from "unknown" to ... - Mailing list pgsql-general

From Ilja Golshtein
Subject failed to find conversion function from "unknown" to ...
Date
Msg-id 42B6AE27.000004.00335@mfront7.yandex.ru
Whole thread Raw
Responses Re: failed to find conversion function from "unknown" to ...
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tomasz Grobelny
Date:
Subject: Re: subqueries
Next
From: John Burger
Date:
Subject: Re: plpgsql constraint checked data fails to restore