hawq-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dominik Choma <dominik.ch...@gmail.com>
Subject cast from TEXT filed
Date Wed, 10 Aug 2016 09:13:04 GMT
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

Mime
View raw message