Postgres append or set each elements(if not exists) of an array to an array column, PostgreSQL

Postgres append or set each elements(if not exists) of an array to an ...

Language: Layout:


absolute service time: 0,39 sec

fork mode | history

  
before update #1

1
{a,b}

2
{a,b,c,d}

3
{a,b,b}


  
after update #1

1
{a,b,c,d}

2
{a,b,c,d}

3
{a,b,c,d}


  
before update #2

1
{a,b}

2
{a,b,c,d}

3
{a,b,b}


  
after update #2

1
{a,b,c,d}

2
{a,b,c,d}

3
{a,b,b,c,d}

λ

                                      .NET NoSQL database for rapid development