Skip to content

Instantly share code, notes, and snippets.

@robinsmidsrod

robinsmidsrod/order_by.diff

Created April 26, 2017 10:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save robinsmidsrod/051f887925b7b43f6a95b057fb8d1484 to your computer and use it in GitHub Desktop.
Save robinsmidsrod/051f887925b7b43f6a95b057fb8d1484 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
order_by.diff
1c1
< (CASE pc.parent_sort_key
---
> (CASE COALESCE(pc.parent_sort_key)
6c6
< (CASE pc.parent_sort_key
---
> (CASE COALESCE(pc.parent_sort_key)
11c11
< (CASE pc.parent_sort_key
---
> (CASE COALESCE(pc.parent_sort_key)
16c16
< (CASE pc.parent_sort_key
---
> (CASE COALESCE(pc.parent_sort_key)
20c20
< (CASE WHEN (pc.parent_sort_key ~~ '%\_asc'::text) THEN collkey((c_1.title)::text, 'nb_NO'::text, false, 0, true)
---
> (CASE WHEN (COALESCE(pc.parent_sort_key) ~~ '%\_asc'::text) THEN collkey((c_1.title)::text, 'nb_NO'::text, false, 0, true)
23c23
< (CASE WHEN (pc.parent_sort_key ~~ '%\_desc'::text) THEN collkey((c_1.title)::text, 'nb_NO'::text, false, 0, true)
---
> (CASE WHEN (COALESCE(pc.parent_sort_key) ~~ '%\_desc'::text) THEN collkey((c_1.title)::text, 'nb_NO'::text, false, 0, true)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment