Re: [BUGS] BUG #5877: problem with wild char used in where clause

2011-02-10 Thread Kevin Grittner
"Savita" wrote: > 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? Oh, I did have one more thought after I posted -- what is the data type of the id c

Re: [BUGS] BUG #5877: problem with wild char used in where clause

2011-02-10 Thread hubert depesz lubaczewski
On Thu, Feb 10, 2011 at 11:02:40AM +, Savita wrote: > 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? is this by any chance char(x) datatype? if yes

Re: [BUGS] BUG #5877: problem with wild char used in where clause

2011-02-10 Thread Kevin Grittner
"Savita" wrote: > PostgreSQL version: 8.3.5 > I have a table with id as primary key. > 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. You might want to check all the bug fixes listed in the 8.3 bug fix releases s

[BUGS] BUG #5877: problem with wild char used in where clause

2011-02-10 Thread Savita
The following bug has been logged online: Bug reference: 5877 Logged by: Savita Email address: savita.ha...@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 prima