"Rui Martins" <Rui(dot)Martins(at)PDMFC(dot)com> writes:
> Here the context of the word "match" may be misleading us, in this
> I say this, because in my report, the second substring expression, the one
> for RoomSize:
> SUBSTRING( BedNo, '^[[:digit:]]+([a-zA-Z]*)(:[[:digit:]]+)?$' ) AS RoomSize,
> Actually returns an EMPTY String, and not a NULL, for the first 2 test
> cases, which I believe is the correct answer.
What's your point? A zero-length substring is a legal match to that
subexpression ... unlike the third one.
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2008-03-19 14:53:22|
|Subject: Re: Problem identifying constraints which should not be inherited |
|Previous:||From: Rui Martins||Date: 2008-03-19 11:42:10|
|Subject: Re: BUG #4044: Incorrect RegExp substring Output|