Thread: INSTR() like function?

In mySQL there is an INSTR(arg1,arg2) function that takes and looks for any
of the characters in arg1 and matches them against arg2

IE are the characters A or B or C or D in the string "dogma" would be
INSTR('ABCD','dogma');

Anyone help me to produce this sort of logic in an PSQL select statement?

PostgreSQL 7.0.2 and 6.5 are present here, solution for 7 series preferable,
and if the answer is to make a stored procedure then that's OK, I would
think that there is a way to do it already though.

Michael

"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

Thanks much!  I never even realised pg had regex built in.

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Thursday, October 12, 2000 2:50 PM
To: Michael Loftis
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] INSTR() like function?


"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