Loading Array
От | Andrew Bartley |
---|---|
Тема | Loading Array |
Дата | |
Msg-id | 000801c1fd2d$784ccfa0$3200a8c0@abartleypc обсуждение исходный текст |
Ответ на | Re: Assertion constraint replacement? (Stephan Szabo <sszabo@megazone23.bigpanda.com>) |
Ответы |
Re: Loading Array
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: