This data as json, CSV (advanced)
Link | pk1 | pk2 | content ▲ | sortable | sortable_with_nulls | sortable_with_nulls_2 | text |
---|---|---|---|---|---|---|---|
a,i | a | i | a-i | 55 | 0.3794554417576478 | $null | |
a,h | a | h | a-h | -29 | 0.37018096711688264 | $null | |
a,f | a | f | a-f | -4 | 0.2931782814070929 | 0.8617069003107772 | $null |
a,e | a | e | a-e | -76 | 0.3589793804846284 | 0.7297317866938179 | $null |
a,c | a | c | a-c | 83 | $null | ||
a,b | a | b | a-b | 51 | 0.6020187290499803 | $null | |
a,a | a | a | a-a | 63 | 0.7364712141640124 | $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) );