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 andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com>
www.visena.com <https://www.visena.com> <https://www.visena.com>