Loading Array

Hi all,

I am trying load an array from a text column.

select '''{' || concatkey || '}''' from visitor where user_id = 477373

returns

'{151038144,0,0,0,0,101931,0,0,0,0}'

This looks like the string I need to load the Array.

But...

create temp table test
(
tesrp int8 [10]
)

insert into test
select '''{' || concatkey || '}''' from visitor where user_id = 477373

returns

Error: ' but expression is of type 'text'
You will need to rewrite or cast the expression (State:S1000, Native Code:
7)

I'm sure I need to CAST the result... But to what type.. I have tried lots
of different things but still carn't work it out.

Can someone help...

Thanks

Andrew