Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id D25D9632215; Tue, 6 Jan 2009 02:23:11 -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 76922-04; Tue, 6 Jan 2009 02:23:08 -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.226]) by mail.postgresql.org (Postfix) with ESMTP id 8EA9F632185; Tue, 6 Jan 2009 02:23:08 -0400 (AST) Received: by rv-out-0506.google.com with SMTP id f9so6904766rvb.7 for ; Mon, 05 Jan 2009 22:23:07 -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:mime-version:content-type; bh=VqP0w2lLFAo9bjIsUm5dM3IcS//Zn0KPjalPSSns1dM=; b=GE8Rb5WjqKbE9xPnIm511ENHYasQ/SGuhoTRF3wAD9n4y5NXaBZL3X35JsZYpJttVJ XJUDMaSeFj9Z0NZE83A/41PMZkMvBInYXeVtXsuQcyuZhKhQpJwdwtb0LCQ0nN7i0DKp SWRmT7sqsDwY8/mkG0nNhk2QwGgpYByAP7hJI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=JMzqYpZ6VZECqfP3P0EVx7XmyKYEbETmHRU9m+7u4YikcNnCMWf0O3U2pBaxRTtHqj y/p4QD6fN6KKByTNELD+bbefiQ41yVQSIoppenE4tkn8Vva7kZgQb6OUcrNaGF4KjTlB SZvm5Yie5n/AVm7JiNnzh/jaOCoEmdOzKPluQ= Received: by 10.141.18.15 with SMTP id v15mr10775167rvi.197.1231222987382; Mon, 05 Jan 2009 22:23:07 -0800 (PST) Received: by 10.141.98.4 with HTTP; Mon, 5 Jan 2009 22:23:07 -0800 (PST) Message-ID: <65937bea0901052223w162a977dyeaaf888a854f7324@mail.gmail.com> Date: Tue, 6 Jan 2009 11:53:07 +0530 From: "Gurjeet Singh" To: "PGSQL General" , "PGSQL Hackers" Subject: ERROR: failed to find conversion function from "unknown" to text MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_49707_2996763.1231222987375" 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/66 X-Sequence-Number: 142151 ------=_Part_49707_2996763.1231222987375 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Q1: select '' union all select '' Q2: select '' union all select * from (select '' ) as s version: PostgreSQL 8.3.1, compiled by Visual C++ build 1400 Hi All, Q1 works just fine, but Q2 fails with: ERROR: failed to find conversion function from "unknown" to text Q2 is a generalization of a huge query we are facing, which we cannot modify. I don't think this is a 'removed-casts' problem generally faced in 8.3, but I may be wrong. Will adding some cast resolve this? 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_49707_2996763.1231222987375 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Q1: select '' union all select ''
Q2: select '' union all select * from (select '' ) as s

version: PostgreSQL 8.3.1, compiled by Visual C++ build 1400

Hi All,

    Q1 works just fine, but Q2 fails with:

ERROR:  failed to find conversion function from "unknown" to text

    Q2 is a generalization of a huge query we are facing, which we cannot modify. I don't think this is a 'removed-casts' problem generally faced in 8.3, but I may be wrong. Will adding some cast resolve this?

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_49707_2996763.1231222987375--