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@sss.pgh.pa.us> wrote:
> "Anton Melser" <melser.anton@gmail.com> 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
>