From: Andrew Sullivan <ajs@crankycanuck.ca>
To: Sz?cs Gábor <surrano@gmail.com>
Cc: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: failed to find conversion function from "unknown" to text
Date: Wed, 12 Jan 2005 12:23:28 -0500
Message-ID: <20050112172328.GD28484@phlogiston.dyndns.org> (raw)
In-Reply-To: <41E555DA.1060707@gmail.com>
References: <41E555DA.1060707@gmail.com>
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
--
Andrew Sullivan | ajs@crankycanuck.ca
Information security isn't a technological problem. It's an economics
problem.
--Bruce Schneier
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: ajs@crankycanuck.ca, surrano@gmail.com
Subject: Re: failed to find conversion function from "unknown" to text
In-Reply-To: <20050112172328.GD28484@phlogiston.dyndns.org>
* 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