På mandag 07. juli 2014 kl. 20:15:16, skrev Vik Fearing mailto:vik.fear...@dalibo.com>>: On 07/07/2014 11:28 AM, Andreas Joseph Krogh
wrote:
> 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-forma
On 07/07/2014 11:28 AM, Andreas Joseph Krogh wrote:
> 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 @> '{"su
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 t
