Skip to content

Instantly share code, notes, and snippets.

@msakrejda

msakrejda/order-by-hijinks

Created January 25, 2013 17:51
Show Gist options
  • Save msakrejda/4636463 to your computer and use it in GitHub Desktop.
Save msakrejda/4636463 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
order-by-hijinks
maciek=# select g as "2", 1.0 / g as "1" from generate_series(1, 3) g order by 2;
2 | 1
---+------------------------
3 | 0.33333333333333333333
2 | 0.50000000000000000000
1 | 1.00000000000000000000
(3 rows)
maciek=# select g as "2", 1.0 / g as "1" from generate_series(1, 3) g order by "2";
2 | 1
---+------------------------
1 | 1.00000000000000000000
2 | 0.50000000000000000000
3 | 0.33333333333333333333
(3 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment