Re: Array string casts with SELECT but not SELECT DISTINCT

On Fri, Feb 20, 2015 at 7:31 PM, sridhar bamandlapally [via PostgreSQL] <
ml-node+s1045698n5838807h41(at)n5(dot)nabble(dot)com> 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: http://postgresql.nabble.com/Array-string-casts-with-SELECT-but-not-SELECT-DISTINCT-tp5838663p5838808.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.