Baldur Norddahl <[EMAIL PROTECTED]> writes: > Seems like "like" knows how to convert bytea to text,
No, it doesn't. The reason that works is there's a LIKE operator for bytea (try "\do ~~" in psql). regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html