Casts to text/varchar - Mailing list pgsql-general

From Greg Stark
Subject Casts to text/varchar
Date
Msg-id 87istbbqo1.fsf@stark.dyndns.tv
Whole thread Raw
Responses Re: Casts to text/varchar  (Dennis Gearon <gearond@cvc.net>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Darko Prenosil
Date:
Subject: Re: Using index for "like 'ABC%'" type query
Next
From: Dennis Gearon
Date:
Subject: Re: Casts to text/varchar