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 9EE1252833 for ; Tue, 19 Jul 2005 09:20:15 -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 11193-06 for ; Tue, 19 Jul 2005 12:20:14 +0000 (GMT) Received: from mfront8.yandex.ru (mfront8.yandex.ru [213.180.200.39]) by svr1.postgresql.org (Postfix) with ESMTP id 256EB52818 for ; Tue, 19 Jul 2005 09:20:13 -0300 (ADT) Received: from YAMAIL (mfront8.yandex.ru) by mail.yandex.ru id ; Tue, 19 Jul 2005 16:19:58 +0400 Date: Tue, 19 Jul 2005 16:19:58 +0400 (MSD) From: "Ilja Golshtein" Message-Id: <42DCEFEE.000005.12199@mfront8.yandex.ru> MIME-Version: 1.0 X-Mailer: Yamail [ http://yandex.ru ] To: dev@archonet.com Cc: pgsql-general@postgresql.org Subject: Re: Old question - failed to find conversion function from "unknown" In-Reply-To: <42DCDE07.4020906@archonet.com> Reply-To: ilejn@yandex.ru References: <42DCC1E9.2060300@aeccom.com> <42DCCCCE.000006.04382@mfront8.yandex.ru> <42DCDE07.4020906@archonet.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.028 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200507/759 X-Sequence-Number: 80857 >Well, it would obviously be better if PG could figure out it was safe, >but I'm not sure there's a general case where it is. You can see it's OK >because you know there's only one row in your SELECT result-set. I think, it's OK because NULL can be compared with anything with predictable result and no additional information about types is necessary. Is it correct vision? I agree it's hard to proceed your query with UNION and some sort of error is reasonable here. -- Best regards Ilja Golshtein