Hypothesis

3 Matching Annotations

Mar 2022
dba.stackexchange.com dba.stackexchange.com

How can I get a unique array in PostgreSQL?

1
1. TylerRick 02 Mar 2022
  
  in Public
  
  ARRAY( SELECT DISTINCT ... FROM unnest(arr) )
  
  PostgreSQL: arrays: unnest
Visit annotations in context

Tags

PostgreSQL: arrays: unnest

Annotators

TylerRick

URL

dba.stackexchange.com/questions/226456/how-can-i-get-a-unique-array-in-postgresql
Jun 2021
www.postgresql.org www.postgresql.org

9.19. Array Functions and Operators

1
1. TylerRick 04 Jun 2021
  
  in Public
  
  unnest ( anyarray ) → setof anyelement Expands an array into a set of rows. The array's elements are read out in storage order.
  
  PostgreSQL: → setof PostgreSQL: arrays PostgreSQL: arrays: unnest
Visit annotations in context

Tags

PostgreSQL: arrays: unnest

PostgreSQL: → setof

PostgreSQL: arrays

Annotators

TylerRick

URL

postgresql.org/docs/14/functions-array.html
dba.stackexchange.com dba.stackexchange.com

How to turn JSON array into Postgres array?

1
1. TylerRick 04 Jun 2021
  
  in Public
  
  PostgreSQL: jsonb PostgreSQL: json: unnest JSON array PostgreSQL: arrays
Visit annotations in context

Tags

PostgreSQL: jsonb

PostgreSQL: arrays

PostgreSQL: json: unnest JSON array

Annotators

TylerRick

URL

dba.stackexchange.com/questions/54283/how-to-turn-json-array-into-postgres-array