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

[Alvaro Herrera <alvherre(at)commandprompt(dot)com>]

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.