Re: failed to find conversion function from "unknown" to text - Mailing list pgsql-sql

From Andrew Sullivan
Subject Re: failed to find conversion function from "unknown" to text
Date
Msg-id 20050112172328.GD28484@phlogiston.dyndns.org
Whole thread Raw
In response to failed to find conversion function from "unknown" to text  (Szűcs Gábor <surrano@gmail.com>)
List 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@crankycanuck.ca
Information security isn't a technological problem.  It's an economics
problem.    --Bruce Schneier


pgsql-sql by date:

Previous
From: Rosser Schwarz
Date:
Subject: Re: Syntax error while altering col-type
Next
From: Sam Mason
Date:
Subject: Re: Problems with HAVING