Sorting array elements

by

The best way to sort an array of integers is without a doubt to use the intarray extension, which will do it much, much, much faster than any SQL formulation:

CREATE EXTENSION intarray;

SELECT sort( ARRAY[4,3,2,1] );

A function that works for any array type is:

CREATE OR REPLACE FUNCTION array_sort (ANYARRAY)
RETURNS ANYARRAY LANGUAGE SQL
AS $$
SELECT ARRAY(SELECT unnest($1) ORDER BY 1)
$$;

(I’ve replaced my version with Pavel’s slightly faster one after discussion elsewhere).

More Related Contents:

  1. Why the “Group BY” by month didn’t work? [closed]
  2. What to do with null values when modeling and normalizing?
  3. Postgres: INSERT if does not exist already
  4. Truncating all tables in a Postgres database
  5. How can I drop all the tables in a PostgreSQL database?
  6. postgres default timezone
  7. quick random row selection in Postgres
  8. Running PostgreSQL in memory only
  9. How to close idle connections in PostgreSQL automatically?
  10. Is it possible to have autoincrement number without it being an ID?
  11. How do I login and authenticate to Postgresql after a fresh install?
  12. pgadmin4 : postgresql application server could not be contacted.
  13. PostgreSQL error ‘Could not connect to server: No such file or directory’
  14. function returns multiple columns as a single column instead of multiple columns
  15. Dynamic pivot query using PostgreSQL 9.3
  16. Strange behaviour in Postgresql
  17. Postgres: Distinct but only for one column
  18. In PostgreSQL, how to insert data with COPY command?
  19. Cursor based records in PostgreSQL
  20. How to add column if not exists on PostgreSQL?
  21. Configuration parameter work_mem in PostgreSQL on Linux
  22. How to work with PGpoint for Geolocation using PostgreSQL?
  23. Heroku database restore issue
  24. user postgres launches process that takes all CPUs 100% usage
  25. PostgreSQL disable more output
  26. PostgreSQL array_agg order
  27. Postgres table column name restrictions?
  28. How do I get min, median and max from my query in postgresql?
  29. PostgreSQL jsonb, `?` and JDBC
  30. Syntax error at end of input in PostgreSQL

Leave a Comment