Re: failed to find conversion function from "unknown" to text

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: Sz?cs Gábor <surrano(at)gmail(dot)com>
Cc: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: failed to find conversion function from "unknown" to text
Date: 2005-01-12 17:23:28
Message-ID: 20050112172328.GD28484@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)crankycanuck(dot)ca
Information security isn't a technological problem. It's an economics
problem.
--Bruce Schneier

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Sam Mason 2005-01-12 17:40:19 Re: Problems with HAVING
Previous Message Rosser Schwarz 2005-01-12 17:22:43 Re: Syntax error while altering col-type