| From: | "Gurjeet Singh" <singh(dot)gurjeet(at)gmail(dot)com> |
|---|---|
| To: | "PGSQL General" <pgsql-general(at)postgresql(dot)org>, "PGSQL Hackers" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | ERROR: failed to find conversion function from "unknown" to text |
| Date: | 2009-01-06 06:23:07 |
| Message-ID: | 65937bea0901052223w162a977dyeaaf888a854f7324@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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[(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 | Pavel Stehule | 2009-01-06 06:30:53 | Re: [HACKERS] ERROR: failed to find conversion function from "unknown" to text |
| Previous Message | Craig Ringer | 2009-01-06 05:39:59 | Re: Per-user schemas with inherited skeleton. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2009-01-06 06:30:53 | Re: [HACKERS] ERROR: failed to find conversion function from "unknown" to text |
| Previous Message | Tom Lane | 2009-01-06 04:58:25 | Re: QuickLZ compression algorithm (Re: Inclusion in the PostgreSQL backend for toasting rows) |