Postgres Pro
Downloads
Home   >   mailing lists

Thread: text-prefix search in 9.4's JSONB

text-prefix search in 9.4's JSONB

From
Andreas Joseph Krogh
Date:
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
Attachment

Re: text-prefix search in 9.4's JSONB

From
Vik Fearing
Date:
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

Re: text-prefix search in 9.4's JSONB

From
Andreas Joseph Krogh
Date:
På mandag 07. juli 2014 kl. 20:15:16, skrev Vik Fearing <vik.fearing@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-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
 
Interesting!
 
--
Andreas Jospeh Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 
Attachment