Re: BUG #3493: Cannot find data with = operator

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.