In fact, not too many ... it just
1. add a zhparser ts config use pg extension,
2. add a stored generated column column to generate tsvector column (“美元”
is not as lexor token)
3. Use following code to add "美元“ as lex token
DB.run(Sequel.lit("INSERT INTO zhparser.zhprs_custom_word values(?) ON
CONFLICT DO NOTHING;", '美元'))
DB.run("SELECT sync_zhprs_custom_word();") # this function i paste
before
4. Run update statement to make generated column column get updated
automatically. (ruby-pg work, sequel not work)
Sorry, i don't know how to add a alphabet lexor into `english` ts config or
whatever to reproduce this issue, maybe can reproduce on that, maybe not.
one more question please, why do you not consider this is a issue relative
to thread?
在2021年11月23日星期二 UTC+8 上午2:59:04<Jeremy Evans> 写道：
> On Mon, Nov 22, 2021 at 10:55 AM Billy Zheng <[email protected]> wrote:
>
>> > I cannot see why the first two would cause a problem, but maybe the
>> last one does? You can turn that off via the :use_iso_date_format=>false
>> option when
>> setting up your Database connection.
>>
>> I consider not caused by those option, because following code still not
>> work. (after revert above hack in acquire method)
>>
>> ```
>> DB = Sequel.connect(DB_URL, :use_iso_date_format => false,
>> :force_standard_strings => false)
>>
>> # many code, ellipsis ...
>>
>> DB.run(Sequel.lit("update investing_latest_news set title=title"))
>>
>
> If you avoid the many code, and run DB.run directly after DB =
> Sequel.connect, does it work then?
>
> Thanks,
> Jeremy
>
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/sequel-talk/1e005109-8625-458e-a6aa-96e591d8856bn%40googlegroups.com.
