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 4EEFE52A25 for ; Tue, 19 Jul 2005 14:24:58 -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 11921-02 for ; Tue, 19 Jul 2005 17:24:49 +0000 (GMT) Received: from mfront8.yandex.ru (mfront8.yandex.ru [213.180.200.39]) by svr1.postgresql.org (Postfix) with ESMTP id C1F5852A15 for ; Tue, 19 Jul 2005 14:24:45 -0300 (ADT) Received: from YAMAIL (mfront8.yandex.ru) by mail.yandex.ru id ; Tue, 19 Jul 2005 21:24:27 +0400 Date: Tue, 19 Jul 2005 21:24:27 +0400 (MSD) From: "Ilja Golshtein" Message-Id: <42DD374B.000003.26351@mfront8.yandex.ru> MIME-Version: 1.0 X-Mailer: Yamail [ http://yandex.ru ] To: tgl@sss.pgh.pa.us Cc: dev@archonet.com, pgsql-general@postgresql.org Subject: Re: Old question - failed to find conversion function from In-Reply-To: <24675.1121786346@sss.pgh.pa.us> Reply-To: ilejn@yandex.ru References: <42DCC1E9.2060300@aeccom.com> <42DCCCCE.000006.04382@mfront8.yandex.ru> <42DCDE07.4020906@archonet.com> <42DCEFEE.000005.12199@mfront8.yandex.ru> <42DD0BB4.6050108@archonet.com> <24675.1121786346@sss.pgh.pa.us> X-Source-Ip: 212.34.61.2 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.024 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200507/781 X-Sequence-Number: 80879 >Richard Huxton writes: >> [* Actually, I think NULLs are typed in SQL, which means you should be >> able to get type violations. ] > >I'm pretty sure the entire construct is illegal per a strict reading of >the SQL spec --- the spec only allows NULL to appear in contexts where a >datatype can be assigned to it immediately. Honestly I cannot say this info changes too much for me (other DBMSs I use as backend handle this untyped NULLs), though the situation is clarified. Thanks a lot. -- Best regards Ilja Golshtein