Re: [HACKERS] Prob with regexp

2001-03-25 Thread Tom Lane
Philippe Rochat <[EMAIL PROTECTED]> writes: > I think there is a prob with regexp, which is comparing one less > character as it should. Below is an example. Result is that last > character is omitted ! Possibly there is a problem with your understanding of regexp patterns ... but all those match

Re: [HACKERS] Prob with regexp

2001-03-25 Thread Peter Eisentraut
Philippe Rochat writes: > I think there is a prob with regexp, which is comparing one less > character as it should. Below is an example. Result is that last > character is omitted ! A '*' means "zero or more of the preceeding character". You probably want a '+'. > > Ph.R. > > postgres=# selec

re : [HACKERS] Prob with regexp

2001-03-26 Thread pejac
Hi, There's no bug with regexp, because "*" operator in regex match zero or more times. So if you want match exactly your patern try ~ 'ibd01.*' . "." match an arbitrary character. Cheers, PEJAC Pascal ---(end of broadcast)--- TIP 5: Have you ch