text-prefix search in 9.4's JSONB - Mailing list pgsql-general

Hi all.

 

I'm excited about 9.4's new JSONB and search-performance.

 

Is it possible to combine tsearch's prefix-search with the new JSONB-format?

 

Something like this (pseudo-code):

SELECT '{"subject": "visena"}'::jsonb @>  '{"subject": to_tsquery('simple', '(vise:*|office:*)')}';

 

and have the above query match documents where subject contains the prefixes "vise" and "office", which would match subject="visena" and subject="officenet"

 

Would be ultimate cool if this was possible!

 

Thanks.