On Fri, Feb 20, 2015 at 7:31 PM, sridhar bamandlapally [via PostgreSQL] < ml-node+s1045698n5838807...@n5.nabble.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.