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 r
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 lo
Good morning,
I am new to Postgres and I have one question. I am trying to get the
following select command to work.
select * from catalog where file_name like 'abc%def%.200[2-5]%';
The following select keeps returning "(0 rows)".
I know that there are many rows in my database that s