failed to find conversion function from "unknown" to text

From: Szűcs Gábor <surrano(at)gmail(dot)com>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: failed to find conversion function from "unknown" to text
Date: 2005-01-12 16:52:42
Message-ID: 41E555DA.1060707@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 text

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

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"?

A similar conversion for name to varchar conversion would also be highly
desirable for easier migration. Right now I'm writing wrapper functions for
all our functions where params might be names.

If it's written in the doc, could you please tell me the page?

TIA,
--
G.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message KÖPFERL Robert 2005-01-12 17:02:10 Syntax error while altering col-type
Previous Message Kaloyan Iliev Iliev 2005-01-12 16:38:51 Problems with HAVING