cast from TEXT filed

[Dominik Choma]

Hi All,

I have some problems with string functions on _TEXT columns
After running  madlib assoc_rules  function  output data  is stored at
result table

        CREATE TABLE {0}.assoc_rules
            (
            ruleId      INT,
            pre         TEXT[],
            post        TEXT[],
            support     FLOAT8,
            confidence  FLOAT8,
            lift        FLOAT8,
            conviction  FLOAT8
            )
        DISTRIBUTED BY (ruleId)

I need to do some text operations like regexp_replace on result column.
in postgreSQL That will do the trick :
select
regexp_replace(pre::varchar(10000),'{|}','','g')
from md.assoc_rules;

but in HAWQ i get error
[42846] ERROR: cannot cast type text[] to character varying


Is there a way to cast from text[] column to varchar ?
Thanks

Dominik