Postgres Pro
Downloads
Home   >   mailing lists

Re: failed to find conversion function from "unknown" to text - Mailing list pgsql-sql

From Tom Lane
Subject Re: failed to find conversion function from "unknown" to text
Date
Msg-id 28633.1105550450@sss.pgh.pa.us
Whole thread Raw
In response to failed to find conversion function from "unknown" to text  (Szűcs Gábor <surrano@gmail.com>)
List pgsql-sql
Tree view 
Szűcs Gábor <surrano@gmail.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

pgsql-sql by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Syntax error while altering col-type
Next
From: Rosser Schwarz
Date:
Subject: Re: Syntax error while altering col-type