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 checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html