Re: Full-Text Search question - Mailing list pgsql-general

From Oleg Bartunov
Subject Re: Full-Text Search question
Date
Msg-id CAF4Au4w0mnee-jaCBMxtKW0bRWstjzusjg0=oCfpRcfPtoBd0g@mail.gmail.com
Whole thread Raw
In response to Full-Text Search question  (Jesus Rafael Sanchez Medrano <jesusrafael@gmail.com>)
Responses Re: Full-Text Search question
List pgsql-general
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"


pgsql-general by date:

Previous
From: Alan Nilsson
Date:
Subject: logging hook
Next
From: Susan Cassidy
Date:
Subject: Re: logging hook