sort_key
Scalar function
Converts INT256/UINT256 to a sortable BLOB for use in ORDER BY. Necessary because DuckDB's default BLOB ordering doesn't handle signed integers correctly.
Overloads
sort_key(INT256)
Parameters
| Name | Type |
|---|---|
| value | INT256 |
Returns
| Name | Type |
|---|---|
| sortable_key | BLOB |
1
SELECT * FROM transfers ORDER BY sort_key(net_flow) DESC;
Notebook ready in readonly mode.
sort_key(UINT256)
Parameters
| Name | Type |
|---|---|
| value | UINT256 |
Returns
| Name | Type |
|---|---|
| sortable_key | BLOB |
1
SELECT * FROM transfers ORDER BY sort_key(net_flow) DESC;
Notebook ready in readonly mode.