3 Matching Annotations
  1. Mar 2022
  2. dba.stackexchange.com dba.stackexchange.com
    How can I get a unique array in PostgreSQL?
    1
    1. TylerRick 02 Mar 2022
      ARRAY( SELECT DISTINCT ... FROM unnest(arr) )
      PostgreSQL: arrays: unnest
    Visit annotations in context

    Tags

    Annotators

    URL

    dba.stackexchange.com/questions/226456/how-can-i-get-a-unique-array-in-postgresql
  3. Jun 2021
  4. www.postgresql.org www.postgresql.org
    9.19. Array Functions and Operators
    1
    1. TylerRick 04 Jun 2021
      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

    Annotators

    URL

    postgresql.org/docs/14/functions-array.html
  5. dba.stackexchange.com dba.stackexchange.com
    How to turn JSON array into Postgres array?
    1
    1. TylerRick 04 Jun 2021
      PostgreSQL: jsonb PostgreSQL: json: unnest JSON array PostgreSQL: arrays
    Visit annotations in context

    Tags

    Annotators

    URL

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