This data as json, CSV (advanced)
Link | pk1 | pk2 | content | sortable | sortable_with_nulls | sortable_with_nulls_2 ▼ | text |
---|---|---|---|---|---|---|---|
a,k | a | k | a-k | -32 | 0.913136124185545 | 0.3146778807984779 | $blah |
b,k | b | k | b-k | -48 | 0.6697259747698292 | 0.3957858467912545 | $blah |
d,k | d | k | d-k | 77 | 0.24330516387675716 | 0.47326048875952476 | $blah |
g,k | g | k | g-k | 24 | 0.7549431436683707 | $null |
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) );