Postgres Pro
Downloads
Home   >   mailing lists

Thread: Full-Text Search question

Full-Text Search question

From
Jesus Rafael Sanchez Medrano
Date:
can postgres do FTS (full text search) on a json column? if possible, please be so kindd to give some snippet/example.


Att.
==
Jesus Rafael Sanchez Medrano
"Life is a dream, of which all must wake up"

Re: Full-Text Search question

From
Oleg Bartunov
Date:
Easy, you need to extract text fields from json and construct tsvector
from them (use concatenation, for example).

On Tue, May 13, 2014 at 7:38 PM, Jesus Rafael Sanchez Medrano
<jesusrafael@gmail.com> wrote:
> can postgres do FTS (full text search) on a json column? if possible, please
> be so kindd to give some snippet/example.
>
>
> Att.
> ==
> Jesus Rafael Sanchez Medrano
> "Life is a dream, of which all must wake up"

Re: Full-Text Search question

From
Jesus Rafael Sanchez Medrano
Date:
thanks... could you please be so kind to post some snippet/code for this?

Att.
==
Jesus Rafael Sanchez Medrano
"Life is a dream, of which all must wake up"


On Tue, May 13, 2014 at 5:33 PM, Oleg Bartunov <obartunov@gmail.com> wrote:
Easy, you need to extract text fields from json and construct tsvector
from them (use concatenation, for example).

On Tue, May 13, 2014 at 7:38 PM, Jesus Rafael Sanchez Medrano
<jesusrafael@gmail.com> wrote:
> can postgres do FTS (full text search) on a json column? if possible, please
> be so kindd to give some snippet/example.
>
>
> Att.
> ==
> Jesus Rafael Sanchez Medrano
> "Life is a dream, of which all must wake up"

Re: Full-Text Search question

From
Dorian Hoxha
Date:
Search for fulltext tutorial  + json functions http://www.postgresql.org/docs/9.3/static/functions-json.html


On Wed, May 14, 2014 at 1:00 AM, Jesus Rafael Sanchez Medrano <jesusrafael@gmail.com> wrote:
thanks... could you please be so kind to post some snippet/code for this?

Att.
==
Jesus Rafael Sanchez Medrano
"Life is a dream, of which all must wake up"


On Tue, May 13, 2014 at 5:33 PM, Oleg Bartunov <obartunov@gmail.com> wrote:
Easy, you need to extract text fields from json and construct tsvector
from them (use concatenation, for example).

On Tue, May 13, 2014 at 7:38 PM, Jesus Rafael Sanchez Medrano
<jesusrafael@gmail.com> wrote:
> can postgres do FTS (full text search) on a json column? if possible, please
> be so kindd to give some snippet/example.
>
>
> Att.
> ==
> Jesus Rafael Sanchez Medrano
> "Life is a dream, of which all must wake up"