Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
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
You can’t perform that action at this time.