In article <[EMAIL PROTECTED]>, Michael Glaesemann <[EMAIL PROTECTED]> writes:
> On Dec 15, 2005, at 0:29 , Jimmy Rowe wrote: >> select * from catalog where file_name like 'abc%def%.200[2-5]%'; >> The following select keeps returning "(0 rows)". > LIKE doesn't consider [2-5] to be a range, but rather the literal > characters '[2-5]'. If you're looking for regex, take a look at the > POSIX regex operator ~ > http://www.postgresql.org/docs/current/interactive/functions- > matching.html#FUNCTIONS-POSIX-REGEXP > See if something like file_name ~ 'abc.*def.*\.200[2-5]' That's not quite the same because LIKE matching is anchored. Try something like file_name ~ '^abc.*def.*\.200[2-5]$' ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
