eliminate duplicate array values in postgres

by

I faced the same. But an array in my case is created via array_agg function. And fortunately it allows to aggregate DISTINCT values, like:

  array_agg(DISTINCT value)

This works for me.

More Related Contents:

  1. What is PostgreSQL equivalent to autoincrement?
  2. How do I specify a password to ‘psql’ non-interactively?
  3. INSERT with dynamic table name in trigger function
  4. psql: FATAL: Ident authentication failed for user “postgres”
  5. Use multiple conflict_target in ON CONFLICT clause
  6. PostgreSQL -must appear in the GROUP BY clause or be used in an aggregate function
  7. How to find table creation time?
  8. What is the format for the PostgreSQL connection string / URL?
  9. Where does PostgreSQL store the database?
  10. How to add “on delete cascade” constraints?
  11. Is there a way to disable function overloading in Postgres
  12. Grant all on a specific schema in the db to a group role in PostgreSQL
  13. Can I make a plpgsql function return an integer without using a variable?
  14. Migrate database from Postgres to MySQL [closed]
  15. How can I start PostgreSQL on Windows?
  16. PostgreSQL – max number of parameters in “IN” clause?
  17. SQLAlchemy, Psycopg2 and Postgresql COPY
  18. Why can I create a table with PRIMARY KEY on a nullable column?
  19. Oracle SQL Developer and PostgreSQL
  20. PostgreSQL array of elements that each are a foreign key
  21. How to reset sequence in postgres and fill id column with new data?
  22. How do you find the disk size of a Postgres / PostgreSQL table and its indexes
  23. no pg_hba.conf entry for host
  24. PostgreSQL – disabling constraints
  25. PostgreSQL authentication method 10 not supported
  26. PostgreSQL INSERT ON CONFLICT UPDATE (upsert) use all excluded values
  27. Hashing a String to a Numeric Value in PostgreSQL
  28. Spring Docker container cannot access Postgres Docker container
  29. Format specifier for integer variables in format() for EXECUTE?
  30. PostgreSQL composite primary key

Leave a Comment