Using Postgres V. 7.4.1, the following query:
SELECT substring('X12345X' FROM '.*?([0-9]{1,5}).*?');
Returns '1'. I would expect it to return '12345'. Is this a bug, or am I missing something? Thanks.
begin:vcard fn:Kenneth Tanzer n:Tanzer;Kenneth org:Downtown Emergency Service Center;Information Services adr:;;507 Third Avenue;Seattle;WA;98104;USA email;internet:[EMAIL PROTECTED] title:IS Manager tel;work:(206) 464-1570 x 3061 tel;fax:(206) 624-4196 url:http://www.desc.org version:2.1 end:vcard
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster