Re: INSTR() like function? - Mailing list pgsql-general

From Tom Lane
Subject Re: INSTR() like function?
Date
Msg-id 28785.971387426@sss.pgh.pa.us
Whole thread Raw
In response to INSTR() like function?  ("Michael Loftis" <taos@activesw.com>)
Responses RE: INSTR() like function?  ("Michael Loftis" <taos@activesw.com>)
List pgsql-general
"Michael Loftis" <taos@activesw.com> writes:
> IE are the characters A or B or C or D in the string "dogma" would be
> INSTR('ABCD','dogma');

See the regular-expression match operators (~ and ~*).  The above would
be
    select  'dogma'::text ~* '[ABCD]'::text;
assuming you meant you wanted case-insensitive match.

            regards, tom lane

pgsql-general by date:

Previous
From: Nelson Brito
Date:
Subject: Problem whith Stored queries
Next
From: Michelle Murrain
Date:
Subject: GUIs, OSes and related