Skip to content

Instantly share code, notes, and snippets.

Created January 30, 2016 01:22
What would you like to do?
plugin_register functions/vector
table_create Users TABLE_NO_KEY
column_create Users names COLUMN_VECTOR ShortText
table_create Words TABLE_PAT_KEY ShortText
column_create Words users COLUMN_INDEX Users names
load --table Users
{"names": ["Alice", "Bob"]},
{"names": ["Tom"]}
select Users --filter 'vector_size(names) == 1' --output_columns 'names' --command_version 2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment