On Thu, 16 Aug 2007, Phoenix Kiula wrote:
1. Even if it were bytea, would it work with regular SQL operators such as regexp and LIKE? 2. Would tsearch2 work with bytea in the future as long as the stuff in it was text?
As far as I know, regexp, [i]like, tsearch2, etc. all require valid text encodings, and so only work with text, not blobs. But I might be wrong. I'm sure the manual would be enlightening. :)
---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
