How do you create a column that is both text field and string attribute?
Despite the new ‘stored’ text function, I think string attributes are still useful in some circumstances, like if want to sort, filter, or group etc.
CREATE TABLE testrt10 (title TEXT indexed, title STRING, category INT);
does not work. There never was rt_field_string (AFAIK!) but could do
rt_field = title rt_attr_string = title
Seems like an option ‘string’ or just ‘attribute’ for TEXT type would be useful, unless missing something.
(actually, ‘string’ would be better, so can open way to also make it say ‘integer’ an option. Not very common, but I often store ‘year’ as both field and integer attribute, not string attribute. Field so users can search by year, but a integer attribute so can do range queries
WHERE year BETWEEN 1990 and 1995 which is more tricky with string attributes.