<btober(at)computer(dot)org> writes:
>> Sounds like you may be using an older version of Pg than me. What
>> version are you running? Only that can tell us how limiting your regex
>> capabilitites are....
> Not that old (I think)!
> PostgreSQL 7.3.4 on i386-redhat-linux-gnu, compiled by GCC
> i386-redhat-linux-gc c (GCC) 3.2.2 20030222 (Red Hat Linux 3.2.2-5)
Nonetheless too old --- 7.4 contains an entirely new regex package.
The one in 7.3 is quite brain-dead compared to any modern regexes...
regards, tom lane