Re: [GENERAL] Full text search question: "01.Bez." --> "Erster Bezirk"

Hello, ​ On Sat, Mar 12, 2016 at 11:40 AM, Johann Höchtl wrote: > I fear I have an involved challenge concerning FTS. > > Assume I have the following text in a column: > > Graz,06.Bez.:Blah > > This parses as: > SELECT alias, description, token FROM ts_debug('german',

Re: [GENERAL] Full-Text Search question

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 jesusraf...@gmail.com wrote: thanks... could you please be so kind to post some snippet/code for this? Att. == Jesus

Re: [GENERAL] Full-Text Search question

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 jesusraf...@gmail.com wrote: can postgres do FTS (full text search) on a json column? if possible, please be so kindd

Re: [GENERAL] Full-Text Search question

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 obartu...@gmail.com wrote: Easy, you need to extract text fields from json and construct