Full-Text Search question
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"
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"
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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:
Show quoted text
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"
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:
Show quoted text
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"