Re: BUG #3493: Cannot find data with = operator - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #3493: Cannot find data with = operator
Date
Msg-id 20070727103549.GA3572@alvh.no-ip.org
Whole thread Raw
In response to BUG #3493: Cannot find data with = operator  ("Michal Niklas" <mn@heuthes.pl>)
Responses Re: BUG #3493: Cannot find data with = operator
List pgsql-bugs
Michal Niklas wrote:

> isof_customer=# insert into customers (name) values ('KIOSK ');
> INSERT 437819002 1
> isof_customer=# select id,name from customers where name='KIOSK ';
>  id | name
> ---------------+------------------
> (0 rows)
>
> isof_customer=# select id,name from customers where name like 'KIOSK ';
>  id | name
> ---------------+------------------
>         218856 | KIOSK
> (1 row)

What's the type of the name column?  Please be specific.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-bugs by date:

Previous
From: "Michal Niklas"
Date:
Subject: BUG #3493: Cannot find data with = operator
Next
From: "Sergey Burladyan"
Date:
Subject: BUG #3494: may be Query Error: subplan does not executed