Re: Full-Text Search question

From: Dorian Hoxha <dorian(dot)hoxha(at)gmail(dot)com>
To: Jesus Rafael Sanchez Medrano <jesusrafael(at)gmail(dot)com>
Cc: obartunov(at)gmail(dot)com, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Full-Text Search question
Date: 2014-05-14 09:04:13
Message-ID: CANsFX04jCO4NNM_WCnH8zJA9H5twC+vE5Bqz-mZDp1vS4Xy8rA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)gmail(dot)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(at)gmail(dot)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(at)gmail(dot)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"
>>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2014-05-14 10:53:07 Re: LDAP authentication not working
Previous Message Dorian Hoxha 2014-05-14 09:02:59 Re: Log Data Analytics : Confused about the choice of Database