From: Szűcs Gábor <surrano@gmail.com>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: failed to find conversion function from "unknown" to text
Date: Wed, 12 Jan 2005 17:52:42 +0100
Message-ID: <41E555DA.1060707@gmail.com> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: surrano@gmail.com
Subject: Re: failed to find conversion function from "unknown" to text
In-Reply-To: <41E555DA.1060707@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox