Skip to content

Instantly share code, notes, and snippets.

@romanitalian

romanitalian/pg_order_by_calculated.sql

Created December 23, 2020 10:56
Show Gist options
  • Save romanitalian/4cf22f5d65e94c4dd5e65f6f0c4fbab7 to your computer and use it in GitHub Desktop.
Save romanitalian/4cf22f5d65e94c4dd5e65f6f0c4fbab7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
pg_order_by_calculated.sql
SELECT * FROM generate_series(1,10) ORDER BY 1::integer DESC; -- 1, 2, 3, ...
SELECT * FROM generate_series(1,10) ORDER BY 1::text DESC; -- 1, 2, 3, ...
SELECT * FROM generate_series(1,10) ORDER BY (2-1) DESC; -- 1, 2, 3, ...
SELECT * FROM generate_series(1,10) ORDER BY 1*1 DESC; -- 1, 2, 3, ...
SELECT * FROM generate_series(1,10) ORDER BY CASE WHEN true THEN 1 ELSE 1 END DESC; -- 1, 2, 3, ...
SELECT * FROM generate_series(1,10) ORDER BY array_position(ARRAY['one','two'], 'one') DESC; -- 1, 2, 3, ...
SELECT * FROM generate_series(1,10) ORDER BY 1 DESC; -- 10, 9, 8, ...
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment