X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id ACA3B528CE for ; Tue, 19 Jul 2005 06:50:30 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 83093-04 for ; Tue, 19 Jul 2005 09:50:26 +0000 (GMT) Received: from mfront8.yandex.ru (mfront8.yandex.ru [213.180.200.39]) by svr1.postgresql.org (Postfix) with ESMTP id D651552886 for ; Tue, 19 Jul 2005 06:50:23 -0300 (ADT) Received: from YAMAIL (mfront8.yandex.ru) by mail.yandex.ru id ; Tue, 19 Jul 2005 13:50:07 +0400 Date: Tue, 19 Jul 2005 13:50:06 +0400 (MSD) From: "Ilja Golshtein" Message-Id: <42DCCCCE.000006.04382@mfront8.yandex.ru> MIME-Version: 1.0 X-Mailer: Yamail [ http://yandex.ru ] To: pgsql-general@postgresql.org Subject: Old question - failed to find conversion function from "unknown" In-Reply-To: <42DCC1E9.2060300@aeccom.com> Reply-To: ilejn@yandex.ru References: <42DCC1E9.2060300@aeccom.com> X-Source-Ip: 194.190.207.155 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.031 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200507/756 X-Sequence-Number: 80854 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