From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | "Gurjeet Singh" <singh(dot)gurjeet(at)gmail(dot)com> |
Cc: | "PGSQL General" <pgsql-general(at)postgresql(dot)org>, "PGSQL Hackers" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [HACKERS] ERROR: failed to find conversion function from "unknown" to text |
Date: | 2009-01-06 06:30:53 |
Message-ID: | 162867790901052230l25b10f08qa35f56856b9cc4c6@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Hello
2009/1/6 Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com>:
> 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?
yes
postgres=# select '' union all select * from (select ''::text ) as s;
?column?
----------
(2 rows)
regards
Pavel Stehule
>
> Best regards,
> --
> gurjeet[(dot)singh](at)EnterpriseDB(dot)com
> singh(dot)gurjeet(at){ gmail | hotmail | indiatimes | yahoo }.com
>
> EnterpriseDB http://www.enterprisedb.com
>
> Mail sent from my BlackLaptop device
>
From | Date | Subject | |
---|---|---|---|
Next Message | Gurjeet Singh | 2009-01-06 06:37:51 | Re: [HACKERS] ERROR: failed to find conversion function from "unknown" to text |
Previous Message | Gurjeet Singh | 2009-01-06 06:23:07 | ERROR: failed to find conversion function from "unknown" to text |
From | Date | Subject | |
---|---|---|---|
Next Message | Gurjeet Singh | 2009-01-06 06:37:51 | Re: [HACKERS] ERROR: failed to find conversion function from "unknown" to text |
Previous Message | Gurjeet Singh | 2009-01-06 06:23:07 | ERROR: failed to find conversion function from "unknown" to text |