dexing for set collections; maybe that affected
> list as well.
>
> Out of curiosity, does a SELECT with only "contains 'b'" work?
>
> Also, try using "set" rather than "list".
>
> -- Jack Krupansky
>
> On Sun, Feb 15, 2015 at 4:
I have a simple table with an indexed list field, but it shows
unexpected behavior when I query the list. Am i doing something incorrect?
create table test (whole text PRIMARY KEY, parts list);
create index on test (parts);
insert into test (whole,parts) values('a', ['a']);
insert into test (whole
