On 10/26/22 17:30, Siddharth Jain wrote:
Hello,
Given a long list like this:
1,2
2,4 --> 2 appears once
7,9
8,9
5,3
2,5 --> note 2 appears twice
I want to load it into this table:
create table tbl (
id integer primary key,
fids integer[]
)
so we will have 2 -> [4,5] where 2 is id and
Hello,
Given a long list like this:
1,2
2,4 --> 2 appears once
7,9
8,9
5,3
2,5 --> note 2 appears twice
I want to load it into this table:
create table tbl (
id integer primary key,
fids integer[]
)
so we will have 2 -> [4,5] where 2 is id and [4,5] are the fids
My actual dataset is very