• Teodor Sigaev's avatar
    Add json(b)_to_tsvector function · 1c1791e0
    Teodor Sigaev authored
    Jsonb has a complex nature so there isn't best-for-everything way to convert it
    to tsvector for full text search. Current to_tsvector(json(b)) suggests to
    convert only string values, but it's possible to index keys, numerics and even
    booleans value. To solve that json(b)_to_tsvector has a second required
    argument contained a list of desired types of json fields. Second argument is
    a jsonb scalar or array right now with possibility to add new options in a
    future.
    
    Bump catalog version
    
    Author: Dmitry Dolgov with some editorization by me
    Reviewed by: Teodor Sigaev
    Discussion: https://www.postgresql.org/message-id/CA+q6zcXJQbS1b4kJ_HeAOoOc=unfnOrUEL=KGgE32QKDww7d8g@mail.gmail.com
    1c1791e0
pg_proc.h 573 KB