Postgres Pro
Downloads
Home   >   mailing lists

ERROR: failed to find conversion function from "unknown" to text - Mailing list pgsql-general

From Gurjeet Singh
Subject ERROR: failed to find conversion function from "unknown" to text
Date
Msg-id 65937bea0901052223w162a977dyeaaf888a854f7324@mail.gmail.com
Whole thread Raw
Responses Re: [HACKERS] ERROR: failed to find conversion function from "unknown" to text
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Per-user schemas with inherited skeleton.
Next
From: "Pavel Stehule"
Date:
Subject: Re: [HACKERS] ERROR: failed to find conversion function from "unknown" to text