Andrew Dunstan <[EMAIL PROTECTED]> writes: > Is it legal to follow escape by anything other than _ % or escape?
Certainly, but once you've compared the first byte you can handle any remaining bytes via the main loop. And in fact the code is already depending on being able to do that --- the use of CHAREQ rather than BYTEEQ is just wasted cycles. > One more thing - I'm thinking of rolling up the bytea matching routines > as well as the text routines to eliminate all the duplication of logic. +1, I think, but I wonder why we had the duplication in the first place. Is there any likelihood that bytea's semantics should diverge from the text case? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend