Ron Peterson <ron.peterson@xxxxxxxxxxxxxx> 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