Revisions to How to force order of WHERE clauses in PostgreSQL?

Post Undeleted by Evan Carroll

occurred Jan 2, 2018 at 5:26

Post Deleted by Evan Carroll

occurred Jan 2, 2018 at 5:25

added 25 characters in body

Source Link

edited Aug 25, 2017 at 0:51

ORDER BY 
  A1 and B1 DESC,
  A1 and B2 OR A2 and B1 DESC,
  A1 and B3 OR A3 and B1 DESC,
  A2 and B3 OR A3 and B2 DESC,
  A3 and B3;B3 DESC;

ORDER BY 
  A1 and B1,
  A1 and B2 OR A2 and B1,
  A1 and B3 OR A3 and B1,
  A2 and B3 OR A3 and B2,
  A3 and B3;

ORDER BY 
  A1 and B1 DESC,
  A1 and B2 OR A2 and B1 DESC,
  A1 and B3 OR A3 and B1 DESC,
  A2 and B3 OR A3 and B2 DESC,
  A3 and B3 DESC;

Source Link

created Aug 24, 2017 at 19:47

ORDER BY 
  A1 and B1,
  A1 and B2 OR A2 and B1,
  A1 and B3 OR A3 and B1,
  A2 and B3 OR A3 and B2,
  A3 and B3;

Return to Answer