Re: SUBSTRING for a regular expression

>
>> I was hopeful that this would work, since I had missed the need to
>> double the back-slash escape character in my original work, but
>> something still isn't right.
>>
>> First I got an error message that psql didn't like the "?" characters
>> in the RE, so I eliminated them and wrote
>
>
> 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)!

crime=# select version();
version
--------------------------------------------------------------------------------
-----------------------------------------------
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)
(1 row)

--Berend Tober