Re: Regular Expressions
"David G. Johnston" <[email protected]> Sun, 4 Nov 2018 12:25:21 -0700
| Newsgroups | gmane.comp.db.postgresql.sql |
|---|---|
| Message-ID | <CAKFQuwYrJxdyXKGB3SYU1Z+=wWupZJ_-kTNb4Ta=D2M2VQSQaQ@mail.gmail.com> |
On Sunday, November 4, 2018, Mark Williams <[email protected]> wrote: > > I can’t figure out how to search myfield for all instances which contain > “text1” AND “text2”. > > In other words | is the OR operator. What is the AND operator. Tried + and > whilst that executes, it doesn’t return matching fields. > > ===================== > > Myfield ~* ‘text1’ AND myfield ~* ‘text2’ > > There is no convenient concept of AND in the sense you want it in Regular > Expressions and “+” has its own meaning of “one or more of the previous > item”. > > David J. > > >