Обсуждение: Operator % and its meaning and use

Поиск
Список
Период
Сортировка

Operator % and its meaning and use

От
Shaozhong SHI
Дата:
Can anyone remind me of the meaning and use of operator %.

It works in one of scripts like  WHERE NOT (street_name % designatedname)

Regards,

David

Aw: Operator % and its meaning and use

От
Karsten Hilbert
Дата:
Dear David,

> Can anyone remind me of the meaning and use of operator %.
 
I can gladly report that I remember having seen relevant documentation on
that operator while Reading up in The Fine Manual on json_to_row following
the hint Ion kindly provided.

It was amazing !  Reading up on that helped my understanding !

Best regards,
Karsten



Re: Operator % and its meaning and use

От
Laurenz Albe
Дата:
On Tue, 2022-02-15 at 11:08 +0000, Shaozhong SHI wrote:
> Can anyone remind me of the meaning and use of operator %.

https://www.postgresql.org/docs/current/pgtrgm.html#PGTRGM-OP-TABLE

Yours,
Laurenz Albe