ORDER BY the IN value list

by

You can do it quite easily with (introduced in PostgreSQL 8.2) VALUES (), ().

Syntax will be like this:

select c.*
from comments c
join (
  values
    (1,1),
    (3,2),
    (2,3),
    (4,4)
) as x (id, ordering) on c.id = x.id
order by x.ordering

More Related Contents:

  1. Sort by column ASC, but NULL values first?
  2. PostgreSQL DISTINCT ON with different ORDER BY
  3. IN vs ANY operator in PostgreSQL
  4. Optimize query with OFFSET on large table
  5. sql ORDER BY multiple values in specific order?
  6. Sorting null values after all others, except special
  7. Sort NULL values to the end of a table
  8. PostgreSQL ORDER BY issue – natural sort
  9. Why do NULL values come first when ordering DESC in a PostgreSQL query?
  10. Alphanumeric sorting with PostgreSQL
  11. PostgreSQL “Column does not exist” but it actually does
  12. Is SELECT or INSERT in a function prone to race conditions?
  13. How do you use script variables in psql?
  14. Best way to check for “empty or null value”
  15. How to avoid multiple function evals with the (func()).* syntax in a query?
  16. Time zone storage in data type “timestamp with time zone”
  17. PostgreSQL parameterized Order By / Limit in table function
  18. Postgres analogue to CROSS APPLY in SQL Server
  19. Get the default values of table columns in Postgres?
  20. Division of integers returns 0
  21. PostgreSQL: how to convert from Unix epoch to date?
  22. Which datatype should be used for currency?
  23. How to return two columns with function
  24. Custom Order in Oracle SQL
  25. Count cumulative total in Postgresql
  26. Prepared Statement on Postgresql in Rails
  27. How to detect query which holds the lock in Postgres?
  28. PostgreSQL how to create a copy of a database or schema?
  29. PostgreSQL: fill NULL values in timeserie query with previous value
  30. Get most common value for each value of another column in SQL

Leave a Comment