Postgres 13

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
-- Type json cannot be ordered

SELECT
    *
FROM (
   SELECT '{"abc": 1}'::json as data
) s
ORDER BY data

ERROR:  could not identify an ordering operator for type json
LINE 9: ORDER BY data
                 ^
HINT:  Use an explicit ordering operator or modify the query.

-- Type json and value (which is also type json) cannot be ordered

SELECT
    *
FROM (
   SELECT '{"abc": 1}'::json as data
) s
ORDER BY data -> 'abc'

ERROR:  could not identify an ordering operator for type json
LINE 8: ORDER BY data -> 'abc'
                 ^
HINT:  Use an explicit ordering operator or modify the query.

-- cast JSON text output into int

SELECT
    *
FROM (
   SELECT '{"abc": 1}'::json as data
) s
ORDER BY (data ->> 'abc')::int

data

{"abc": 1}

SELECT 1

-- order by type jsonb

SELECT
    *
FROM (
   SELECT '{"abc": 1}'::jsonb as data
) s
ORDER BY data

data

{"abc": 1}

SELECT 1

-- order by type jsonb/value

SELECT
    *
FROM (
   SELECT '{"abc": 1}'::jsonb as data
) s
ORDER BY data -> 'abc'

data

{"abc": 1}

SELECT 1