BUG #5877: problem with wild char used in where clause
От | Savita |
---|---|
Тема | BUG #5877: problem with wild char used in where clause |
Дата | |
Msg-id | 201102101102.p1AB2eCZ025163@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #5877: problem with wild char used in where
clause
Re: BUG #5877: problem with wild char used in where clause Re: BUG #5877: problem with wild char used in where clause |
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 5877 Logged by: Savita Email address: savita.halli@gmail.com PostgreSQL version: 8.3.5 Operating system: Solaris Description: problem with wild char used in where clause Details: I have a table with id as primary key. "slect id from table" gives me following data id -------------- AB1 AB2 AB3 AB4 (4 rows) Now when I need ids which starts from A select id from table where id like 'A%'; Gives the follwoing result set. id -------------- AB1 AB2 AB3 AB4 (4 rows) When I ran query to get the ids which ends with B1 select id from table where id like '%B1' does not return me any rows. Should it be not returning row with id AB1? Is there known issue? Thanks in advance Savita
В списке pgsql-bugs по дате отправления: