In 7.4 I am finding that '(' (and some other punctuation) is not a member of [:print:]. It is in 7.3. It is a member of [:graph:] in 7.4 (which is supposed to be [:print:] - [:space:]).
The following is my 7.4 config: ./configure --prefix=/usr/local/pgsql --enable-integer-datetimes --with-pgport=5433 For 7.3 I used: ./configure --prefix=/usr/lib/pgsql --exec-prefix=/usr --with-perl --with-openssl --mandir=/usr/man --docdir=/usr/doc --enable-integer-datetimes The following is an example of the problem: area=> select version(); version ------------------------------------------------------------------------ PostgreSQL 7.4beta3 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66 (1 row) area=> select '(' ~ '[[:print:]]'; ?column? ---------- f (1 row) area=> select '(' ~ '[[:graph:]]'; ?column? ---------- t (1 row) area=> select '0' ~ '[[:print:]]'; ?column? ---------- t (1 row) ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]