Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 20E5663225E;
	Tue,  6 Jan 2009 09:38:35 -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 57053-08; Tue,  6 Jan 2009 09:38:26 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from rv-out-0506.google.com (rv-out-0506.google.com
 [209.85.198.230])
	by mail.postgresql.org (Postfix) with ESMTP id AB65A63227F;
	Tue,  6 Jan 2009 09:38:25 -0400 (AST)
Received: by rv-out-0506.google.com with SMTP id b25so9150484rvf.43
	for <multiple recipients>; Tue, 06 Jan 2009 05:38:22 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:cc:in-reply-to:mime-version:content-type:references;
	bh=SAluc4eTVgQBfYMkDMP3y5g5vNzSNOHtgCNPkABCbLE=;
	b=EPsiKLmxk9PxArllTLxaHpqrxHGHuZjx5mxBpHZFA2C9SZAQTz4enROSXaFU/aw3mX
	oaJZM3zm4lLijDLZpL8nuEAXZN6u5mOb4P8d9Xrrv2AAqAxkZLVKrXvBWaGQ+2U1vaMh
	wZnWbuQhIcNwaqrVaZE1izHsZhYrOKU+s3jUg=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version
	:content-type:references;
	b=HRR1VuREZBcA408UHWLe9Ph+u/qqpOQY48VXg7a6ZdHvtBkOKnQJZ0bjj2Mce7WHdW
	D9950SPWwM/K/ITMwITWb4XF2qzj9k+OfxEv/lWn4ttAkoWCZs7jcd2dR2OrktFwo3Nr
	8VQQzDyO9Ms+EMypGOvcCH9l1dERmF2okBziU=
Received: by 10.141.197.21 with SMTP id z21mr10939564rvp.267.1231249101953;
	Tue, 06 Jan 2009 05:38:21 -0800 (PST)
Received: by 10.141.98.4 with HTTP; Tue, 6 Jan 2009 05:38:21 -0800 (PST)
Message-ID: <65937bea0901060538n13099005p62f05ef60ed352bd@mail.gmail.com>
Date: Tue, 6 Jan 2009 19:08:21 +0530
From: "Gurjeet Singh" <singh.gurjeet@gmail.com>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Subject: Re: [HACKERS] ERROR: failed to find conversion function from
	"unknown" to text
Cc: "Pavel Stehule" <pavel.stehule@gmail.com>,
	"PGSQL General" <pgsql-general@postgresql.org>,
	"PGSQL Hackers" <pgsql-hackers@postgresql.org>
In-Reply-To: <7588.1231246899@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_53290_13969257.1231249101939"
References: <65937bea0901052223w162a977dyeaaf888a854f7324@mail.gmail.com>
	<162867790901052230l25b10f08qa35f56856b9cc4c6@mail.gmail.com>
	<65937bea0901052237j50657573i8c980f9f5f4814d5@mail.gmail.com>
	<162867790901052245l4e4fa9b2ydc03781b45b13276@mail.gmail.com>
	<65937bea0901060104n399cdec8ye5e2b8e247e5139a@mail.gmail.com>
	<7588.1231246899@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200901/78
X-Sequence-Number: 142163

------=_Part_53290_13969257.1231249101939
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On Tue, Jan 6, 2009 at 6:31 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> "Gurjeet Singh" <singh.gurjeet@gmail.com> 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
>

I guessed so, but couldn't figure out exactly how! That's why I have
suggested this as a temp solution until we confirmed this with someone more
knowledgeable.

Can you please let us know how this would be problematic? And can you
suggest a better solution?

Thanks and best regards,
-- 
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com

EnterpriseDB      http://www.enterprisedb.com

Mail sent from my BlackLaptop device

------=_Part_53290_13969257.1231249101939
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On Tue, Jan 6, 2009 at 6:31 PM, Tom Lane <span dir="ltr">&lt;<a href="mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>&gt;</span> wrote:<br><div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="Ih2E3d">&quot;Gurjeet Singh&quot; &lt;<a href="mailto:singh.gurjeet@gmail.com">singh.gurjeet@gmail.com</a>&gt; writes:<br>
&gt; create cast (unknown as text) with function unknown2text( unknown ) as<br>
&gt; implicit;<br>
<br>
</div>This is a horrendously bad idea; it will bite your *ss sooner or later,<br>
probably sooner.<br>
<br>
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;regards, tom lane<br>
</blockquote></div><br>I guessed so, but couldn&#39;t figure out exactly how! That&#39;s why I have suggested this as a temp solution until we confirmed this with someone more knowledgeable.<br><br>Can you please let us know how this would be problematic? And can you suggest a better solution?<br>
<br>Thanks and best regards,<br>-- <br>gurjeet[.singh]@EnterpriseDB.com<br>singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com<br><br>EnterpriseDB &nbsp; &nbsp; &nbsp;<a href="http://www.enterprisedb.com">http://www.enterprisedb.com</a><br>
<br>Mail sent from my BlackLaptop device<br>

------=_Part_53290_13969257.1231249101939--