Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 757F563221E; Tue, 6 Jan 2009 09:01:51 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 50945-08; Tue, 6 Jan 2009 09:01:45 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 94630632223; Tue, 6 Jan 2009 09:01:44 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id n06D1d8l007589; Tue, 6 Jan 2009 08:01:39 -0500 (EST) To: "Gurjeet Singh" cc: "Pavel Stehule" , "PGSQL General" , "PGSQL Hackers" Subject: Re: [HACKERS] ERROR: failed to find conversion function from "unknown" to text In-reply-to: <65937bea0901060104n399cdec8ye5e2b8e247e5139a@mail.gmail.com> References: <65937bea0901052223w162a977dyeaaf888a854f7324@mail.gmail.com> <162867790901052230l25b10f08qa35f56856b9cc4c6@mail.gmail.com> <65937bea0901052237j50657573i8c980f9f5f4814d5@mail.gmail.com> <162867790901052245l4e4fa9b2ydc03781b45b13276@mail.gmail.com> <65937bea0901060104n399cdec8ye5e2b8e247e5139a@mail.gmail.com> Comments: In-reply-to "Gurjeet Singh" message dated "Tue, 06 Jan 2009 14:34:25 +0530" Date: Tue, 06 Jan 2009 08:01:39 -0500 Message-ID: <7588.1231246899@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200901/77 X-Sequence-Number: 142162 "Gurjeet Singh" writes: > create cast (unknown as text) with function unknown2text( unknown ) as > implicit; This is a horrendously bad idea; it will bite your *ss sooner or later, probably sooner. regards, tom lane