Re: [SQL] Regular Expression in SQL

2006-07-15 Thread Tom Lane
"Aaron Bono" <[EMAIL PROTECTED]> writes: > I thought by using the FOR '#' I could specify exactly what part of the > expression I would get but it still grabs the first (...) of the pattern. Hmm ... I think that this is a bug in similar_escape(): it ought to transform parentheses in a SIMILAR patt

[SQL] Regular Expression in SQL

2006-07-15 Thread Aaron Bono
I recall not long ago a discussion about regular expressions in a query that hit on this exact topic but don't think it was ever resolved so I am giving it a go again...Here is my query (keep in mind that I am just experimenting now so don't worry about the fact that I am using nested substring fun