sortable
8 rows where pk2 = "f"
This data as json, CSV (advanced)
Link | pk1 | pk2 | content | sortable | sortable_with_nulls | sortable_with_nulls_2 | text |
---|---|---|---|---|---|---|---|
e,f | e | f | e-f | 68 | 0.18758254139452712 | $blah | |
f,f | f | f | f-f | 35 | 0.2569700845632623 | $blah | |
g,f | g | f | g-f | 9 | 0.9745466021257082 | $blah | |
h,f | h | f | h-f | 71 | 0.9471086244193812 | 0.09345296506602174 | $blah |
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) );