Search Postgresql Archives

Question on the use of bracket expressions in Postgres

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 should be returned because I first did a
select * from catalog where file_name like 'abc%def%.200%';

I've tried escaping the [ and ] metacharacters and even the - but I got the same results: (0 rows).

What is the correct syntax to pull out a range of data from my database?

Thanks.

Jimmy



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux