From: | Vik Fearing <vik(dot)fearing(at)dalibo(dot)com> |
---|---|
To: | Andreas Joseph Krogh <andreas(at)visena(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: text-prefix search in 9.4's JSONB |
Date: | 2014-07-07 18:15:16 |
Message-ID: | 53BAE3B4.8060508@dalibo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 @> '{"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!
This will absolutely not happen in 9.4 but something like it is being
worked on for 9.5
See this presentation, starting at page 17:
http://www.pgcon.org/2014/schedule/attachments/318_pgcon-2014-vodka.pdf
--
Vik
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Joseph Krogh | 2014-07-07 18:36:31 | Re: text-prefix search in 9.4's JSONB |
Previous Message | Andy Colson | 2014-07-07 16:36:14 | Re: conditional IF statements in postgresql |