Hi Tom
> "Rui Martins" <[EMAIL PROTECTED]> writes:
>> My reasoning is:
>> Why would the exact same sub-expression, return different results when
>> either preceded or followed by something.
>
> It *isn't* returning different results; you are t
> "Rui Martins" <[EMAIL PROTECTED]> writes:
>> Even though this can me though as argumentative, think about this
>> expression:
>
>> (something)?
>
>> Will "match" with an empty string in the context of a full expression,
>> and
>
rence the expected correct result should be and EMPTY string too!
But If I understood you correctly, you said that it will return a result
of NULL, which I think is incorrect.
Did I make my self clearer know ?
Thanks again for feedback.
See ya
Rui Martins
> "Rui Martins" <[EMAIL
Hi Tom
Just a side note, See comments below.
> "Rui Martins" <[EMAIL PROTECTED]> writes:
>> Description:Incorrect RegExp substring Output
>
>>SUBSTRING( BedNo FROM '^[[:digit:]]+[a-zA-Z]*(:[[:digit:]]+)?$' )
>
> Interesting.
> "Rui Martins" <[EMAIL PROTECTED]> writes:
>> Description:Incorrect RegExp substring Output
>
>>SUBSTRING( BedNo FROM '^[[:digit:]]+[a-zA-Z]*(:[[:digit:]]+)?$' )
>
> Interesting. It had never occurred to me that it's pos
The following bug has been logged online:
Bug reference: 4044
Logged by: Rui Martins
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3
Operating system: Win2000
Description:Incorrect RegExp substring Output
Details:
To setup for test, run these SQL commands
