Operator % and its meaning and use

Started by Shaozhong SHIabout 4 years ago3 messagesgeneral
Jump to latest
#1Shaozhong SHI
shishaozhong@gmail.com

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

#2Karsten Hilbert
Karsten.Hilbert@gmx.net
In reply to: Shaozhong SHI (#1)
Aw: Operator % and its meaning and use

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

#3Laurenz Albe
laurenz.albe@cybertec.at
In reply to: Shaozhong SHI (#1)
Re: Operator % and its meaning and use

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