Old question - failed to find conversion function from "unknown"

Поиск
Список
Период
Сортировка
От Ilja Golshtein
Тема Old question - failed to find conversion function from "unknown"
Дата
Msg-id 42DCCCCE.000006.04382@mfront8.yandex.ru
обсуждение исходный текст
Ответ на dump/restore needed when switching from 32bit to 64bit processor architecture?  (Dirk Lutzebäck <lutzeb@aeccom.com>)
Ответы Re: Old question - failed to find conversion function from  (Richard Huxton <dev@archonet.com>)
Список pgsql-general
Hi!

I've already asked this question a month ago -
it remains unanswered.
Dare to repeat since this issue is rather important for me.

So.

When I invoke

select 1 where 5 in (null)

everything is Ok,
though when I try

select 1 where 5 in (select null)

I get

ERROR:  failed to find conversion function from "unknown" to integer.

Is it desired behavior or subject to change
in future versions of PG?

I realize my simplified example looks radiculous while it came from reality.
Sometimes my engine generates SQL queries does not know correct type
and unable to cast, while PostgreSQL should have all information required.

Thanks.

--
Best regards
Ilja Golshtein

В списке pgsql-general по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Converting MySQL tinyint to PostgreSQL
Следующее
От: Dennis Bjorklund
Дата:
Сообщение: Re: index row size exceeds btree maximum, 2713 - Solutions?