=?ISO-8859-2?Q?Sz=FBcs_G=E1bor?= <[EMAIL PROTECTED]> 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.
On Wed, Jan 12, 2005 at 05:52:42PM +0100, Sz?cs Gábor wrote:
> Question: is there a way to tell the server to convert unknown to something
> (text or varchar, don't really care), or to write such a "conversion
> function"?
You ought to be able to cast (e.g. "SELECT case 'a'::text. . .)
A
--
A
Dear Gurus,
Version: 8.0.0rc4
The scene below might look funny but it's essential for our project:
[local]:tir=# select 'a' as asdf;
asdf
--
a
(1 row)
[local]:tir=# select case 'a' when 'a' then 1 else 2 end as asdf;
ERROR: failed to find conversion function from "unknown" to t
