Re: [GENERAL] jsonb

2017-11-14 Thread hmidi slim
Product.query().where('id',1).then(prod => {console.log(prod)}) I think that the problem maybe with the usage of to_jsonb function, maybe I miss something. But when I fetch the data with the ORM I found that the type was a string and not a jsonb 2017-11-14 23:09 GMT+01:00 Merlin Mon

[GENERAL] jsonb

2017-11-14 Thread hmidi slim
I have a column name of type 'jsonb' on my table named product. The format of the column: name: {"key1": "text1", "key2": "text2"} When I make a query to fetch data from the table I got this format: name: '{"key1": "text1", "key2": "text2"}' Why does postgresql returns the name such as string typ

Re: [GENERAL] Spelling dictionaries

2017-11-10 Thread hmidi slim
What about pg_similarity https://github.com/eulerto/pg_similarity. Do you have any idea about this? 2017-11-10 10:36 GMT+01:00 Arthur Zakirov : > On Fri, Nov 10, 2017 at 10:16:06AM +0100, hmidi slim wrote: > > Hi, > > I'm using Full Text search and I'm interested on us

[GENERAL] Spelling dictionaries

2017-11-10 Thread hmidi slim
Hi, I'm using Full Text search and I'm interested on using spelling dictionary. I found a website that has a special functionality, for example when I enter the word 'activities' it gives me the suggestions containing this word. But when I enter the word 'activityns' it returns 'No result for 'acti

Re: [GENERAL] Combine multiple text search configuration

2017-11-06 Thread hmidi slim
for big amount of data. Is it? 2017-11-06 20:46 GMT+01:00 Johannes Graƫn : > Hi, > > > On 2017-11-06 09:17, hmidi slim wrote: > > Hi, > > I want to know if I can combine multiple text search configurations when > > I tried to use FTS. > > Is t

[GENERAL] Combine multiple text search configuration

2017-11-06 Thread hmidi slim
Hi, I want to know if I can combine multiple text search configurations when I tried to use FTS. Is there any options like this: *to_tsvector(['english', 'french'], document)* Trying to create a new text configuration: *Create text search configuration test (copy=simple)* *Alter text search config