sortable
7 rows where pk2 = "t"
This data as json, CSV (advanced)
Link | pk1 | pk2 | content | sortable | sortable_with_nulls | sortable_with_nulls_2 | text |
---|---|---|---|---|---|---|---|
e,t | e | t | e-t | 61 | $null | ||
f,t | f | t | f-t | -56 | 0.26536750832497336 | 0.5260855265978671 | $blah |
g,t | g | t | g-t | -40 | 0.760215295546892 | $null |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE sortable ( pk1 varchar(30), pk2 varchar(30), content text, sortable integer, sortable_with_nulls real, sortable_with_nulls_2 real, text text, PRIMARY KEY (pk1, pk2) );