Re: [BUGS] substring with this pattern works in 8.3.1; does not work in 8.3.4

On 2008-11-12 19:07, Chris Wood wrote: > here is where it works in 8.3.1: > CONSTRAINT public_phone_ch CHECK (((public_phone = ''::text) OR > ("substring"(public_phone, '^[0-9]{10}(,[0-9]{10})*$'::text) IS NOT NULL; > protocalte=> insert into locn values(10, '1231231234') ; 8.3.1 had a bu

[BUGS] substring with this pattern works in 8.3.1; does not work in 8.3.4

I apologize in advance for not testing on 8.3.5, but that would be very difficult for me. here is where it works in 8.3.1: protocalte=> select version() ; version Pos