Re: Casting to varchar - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Casting to varchar
Date
Msg-id 20070504204637.GC26685@alvh.no-ip.org
Whole thread Raw
In response to Casting to varchar  (Scott Ribe <scott_ribe@killerbytes.com>)
Responses Re: Casting to varchar
List pgsql-general
Scott Ribe wrote:
> Just discovered (the hard way) that casting a boolean column ::varchar
> doesn't work. I assume I can add a function somewhere that will define a
> default cast for this?

Sure, see CREATE CAST.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: Casting to varchar
Next
From: Alvaro Herrera
Date:
Subject: Re: Casting to varchar