Re: Casting to varchar

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Glaesemann <grzm(at)seespotcode(dot)net>
Cc: Scott Ribe <scott_ribe(at)killerbytes(dot)com>, Postgresql General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Casting to varchar
Date: 2007-05-04 21:49:13
Message-ID: 11124.1178315353@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Michael Glaesemann <grzm(at)seespotcode(dot)net> writes:
> On May 4, 2007, at 15:34 , Scott Ribe wrote:
>> Are there any other standard types that can't be cast
>> to varchar?

> You already got an answer to the first part of your question, but I
> thought you might be interested in the second as well.

Note that there's a proposal to allow explicit casts to text from any
type (by invoking the appropriate I/O function behind the scenes) and
I imagine we'd allow casts to varchar as well. Not sure if this will
happen for 8.3, although it still could.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2007-05-04 21:54:17 Re: varchar as primary key
Previous Message Martijn van Oosterhout 2007-05-04 21:45:56 Re: varchar as primary key