"Rui Martins" <Rui(dot)Martins(at)pdmfc(dot)com> writes:
> Description: Incorrect RegExp substring Output
> SUBSTRING( BedNo FROM '^[[:digit:]]+[a-zA-Z]*(:[[:digit:]]+)?$' )
Interesting. It had never occurred to me that it's possible for the
whole pattern to have a match when some parenthesized subexpression
has no match. On investigation, Tcl's regex library seems to get
this right, but textregexsubstr() doesn't. Will fix.
> I would expect the result for BedNumber to be either NULL or the EMPTY
> String, and the later seems more logical.
It's going to be null. Your example has no match to the parenthesized
substring --- a match would have to include a colon and some digits, no?
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: kusum||Date: 2008-03-19 05:33:45|
|Subject: BUG #4046: Error on connection|
|Previous:||From: Chan, Keith (LESA IT)||Date: 2008-03-18 20:38:05|
|Subject: Re: BUG #4041: error in Application Stack Builder|