Re: [GENERAL] Question on the use of bracket expressions in Postgres

2005-12-15 Thread Harald Fuchs
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

Re: [GENERAL] Question on the use of bracket expressions in Postgres

2005-12-14 Thread Michael Glaesemann
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

[GENERAL] Question on the use of bracket expressions in Postgres

2005-12-14 Thread Jimmy Rowe
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