Intellectually challenged Anton strikes again! I wanted +, not *. Sometimes I think I'm not cut out for IT! :-( Thanks heaps, Anton On 23/02/07, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
"Anton Melser" <melser.anton@xxxxxxxxx> writes: > I am trying to understand the function substring. You haven't actually said anything that sounded surprising; and in any case, without seeing the data being operated on, we can't comment much on what's happening. I will note that '=([0-9]*)' is going to match to the *first* "=" in the string, whether there happen to be any digits after it or not, because the *-construct can match zero characters. regards, tom lane