Postgres Pro
Downloads
Home   >   mailing lists

Re: Array string casts with SELECT but not SELECT DISTINCT - Mailing list pgsql-general

From David G Johnston
Subject Re: Array string casts with SELECT but not SELECT DISTINCT
Date
Msg-id CAKFQuwYBu6cwaLmsM8qLeEYoxpLxC_BGLE2cXmBfmUMymihK5Q@mail.gmail.com
Whole thread Raw
In response to Re: Array string casts with SELECT but not SELECT DISTINCT  (sridhar bamandlapally <sridhar.bn1@gmail.com>)
List pgsql-general
Tree view
On Fri, Feb 20, 2015 at 7:31 PM, sridhar bamandlapally [via PostgreSQL] <[hidden email]> wrote:
>>>ERROR:  column "my_array" is of type character varying[] but expression is of type text

please try this below, may be this should help

CREATE CAST (text AS varchar) WITH INOUT AS IMPLICIT;

just for info:
actually this should be available in default


​What is the point of doing this?  Did you do this and then run the OP's query and see if it solved the problem?  Do you understand the "type[]" means "array version of type"?

David J.​
 

View this message in context: Re: Array string casts with SELECT but not SELECT DISTINCT
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: sridhar bamandlapally
Date:
Subject: Re: Array string casts with SELECT but not SELECT DISTINCT
Next
From: Ken Tanzer
Date:
Subject: Re: Array string casts with SELECT but not SELECT DISTINCT