Skip to content

Instantly share code, notes, and snippets.

@simonista

simonista/gist:2631125

Created May 7, 2012 22:40
Show Gist options
  • Save simonista/2631125 to your computer and use it in GitHub Desktop.
Save simonista/2631125 to your computer and use it in GitHub Desktop.
Download ZIP
sql-question
Raw
gistfile1.sql
select id, avatar_image_url as aiu from users order by aiu; -- works!
select id, avatar_image_url as aiu from users order by coalesce(avatar_image_url, 'zzz'); -- works!
select id, avatar_image_url as aiu from users order by coalesce(aiu, 'zzz'); -- doesn't work :(
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment