On May 31, 2006, at 5:17 AM, Nis Jorgensen wrote:
You should be able to do this with regular expressions (substituting all invalid chars) on the text columns of the result set(s). I write "should be", since I don't remember the capabilities of pg regular expressions.
I thought about this, but I don't see how to make it work to transform every character. The substring function accepts POSIX regular expressions, but the replace function does not. Maybe I can put something together using substring and position.
Thanks, John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
