Emi Lu wrote: > Is there a simple way/command/function to check whether two > strings have at least one overlap character please? > > For example, > > str1: 05baaa > str2: ooboo > > Query: select str1 ??? str2 ; > > Result: true > > Because b is in both str1 and str2.
SELECT str1 ~ ( '[' || str2 || ']'); See http://www.postgresql.org/docs/current/static/functions-matching.html#FU NCTIONS-POSIX-REGEXP Yours, Laurenz Albe ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
