Thread: programming 'like' operator

programming 'like' operator

From
Ron Peterson
Date:
Anyone have any tips for an earnest aspiring but somewhat befuddled
PostgreSQL acolyte as to what's required to program (in C) a 'like'
operator for a user defined type?

--
Ron Peterson
https://www.yellowbank.com/

Re: programming 'like' operator

From
Tom Lane
Date:
Ron Peterson <ron.peterson@yellowbank.com> writes:
> Anyone have any tips for an earnest aspiring but somewhat befuddled
> PostgreSQL acolyte as to what's required to program (in C) a 'like'
> operator for a user defined type?

Well, you could look at the existing code which is in
    src/backend/utils/adt/like.c
    src/backend/utils/adt/like_match.c
The text variant is a bit obfuscated because it tries to support
both case-sensitive and case-insensitive matching with only one
set of code --- the bytea variant might be easier to follow.

            regards, tom lane