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.
--
Andreas Jospeh Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
