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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Szűcs Gábor <surrano(at)gmail(dot)com>
Cc: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: failed to find conversion function from "unknown" to text
Date: 2005-01-12 17:20:50
Message-ID: 28633.1105550450@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

=?ISO-8859-2?Q?Sz=FBcs_G=E1bor?= <surrano(at)gmail(dot)com> writes:
> [local]:tir=# select case 'a' when 'a' then 1 else 2 end as asdf;
> ERROR: failed to find conversion function from "unknown" to text

> This worked up to v7.4.6, and couldn't see it in the "Migration" part of the
> HISTORY file.

This is an unintended side effect of the change to evaluate CASE
constructs more efficiently. I'll fix it.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Rosser Schwarz 2005-01-12 17:22:43 Re: Syntax error while altering col-type
Previous Message Michael Fuhr 2005-01-12 17:17:56 Re: Syntax error while altering col-type