![Can someone kindly clarify what is the meaning of this default value ARRAY[]::character varying[]::character varying(255)[] : r/PostgreSQL Can someone kindly clarify what is the meaning of this default value ARRAY[]::character varying[]::character varying(255)[] : r/PostgreSQL](https://preview.redd.it/can-someone-kindly-clarify-what-is-the-meaning-of-this-v0-769vzyljae981.png?auto=webp&s=f10dcd9e4520d5ab311fa25543cb5d0d19f2f7c7)
Can someone kindly clarify what is the meaning of this default value ARRAY[]::character varying[]::character varying(255)[] : r/PostgreSQL
KB45016: "ERROR: value too long for type character varying(4000)" appears when upgrading a PostgreSQL metadata to MicroStrategy 9.x or 10.x
![types - PostgreSQL difference between "character varying" and "character varying[]" via pgAdmin - Stack Overflow types - PostgreSQL difference between "character varying" and "character varying[]" via pgAdmin - Stack Overflow](https://i.stack.imgur.com/bZj1N.png)
types - PostgreSQL difference between "character varying" and "character varying[]" via pgAdmin - Stack Overflow
![ERROR: function replace(character varying[], character varying, character varying) does not exist - Get Help - Metabase Discussion ERROR: function replace(character varying[], character varying, character varying) does not exist - Get Help - Metabase Discussion](https://discourse.metabase.com/uploads/default/original/2X/2/23e6484e783b3bdcedd0f21bd801f3b00046ed3d.png)