Check whether two strs have at least one shared character. - Mailing list pgsql-general

From Emi Lu
Subject Check whether two strs have at least one shared character.
Date
Msg-id 468A5392.6020002@encs.concordia.ca
Whole thread Raw
List pgsql-general
Hello,

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.

Thank you!

pgsql-general by date:

Previous
From: Peter Wiersig
Date:
Subject: Re: how to: psql -U user --password password ?
Next
From: "Albe Laurenz"
Date:
Subject: Re: Check whether two strs have at least one shared character.