Closed helloiamlukas closed 1 year ago
When sorting numeric fields, the order of the results is not as expected.
1 3 22
1 22 3
This problem is caused by the fact that the column will be converted to a string when running the query:
order by "data"->>'number' asc
To solve this, the query should look like this (for numeric fields):
order by "data"->'number' asc
Description
When sorting numeric fields, the order of the results is not as expected.
Expected sorting order
Actual sorting order
This problem is caused by the fact that the column will be converted to a string when running the query:
To solve this, the query should look like this (for numeric fields):