Re: Casts to text/varchar - Mailing list pgsql-general

From Dennis Gearon
Subject Re: Casts to text/varchar
Date
Msg-id 3EA0524E.6040201@cvc.net
Whole thread Raw
In response to Casts to text/varchar  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
Don't know,
good point,
looking forward to the answer :0(

Greg Stark wrote:
> ERROR:  Cannot cast type integer[] to character varying
>
> I would think every datatype should have at least one cast, the cast to a text
> or varchar. Otherwise how is an application to know how to print an arbitrary
> unknown type for human consumption? Where do the existing "{...}"
> representations get created and how does one invoke that in a query?
>
> --
> greg
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>


pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Casts to text/varchar
Next
From: Robert Treat
Date:
Subject: Re: 7.3 PDF documentation