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

The schema specification you provided doesn't even include the column
"name", which you are selecting in your original message. What is
the field type of "name" ?

On Jul 27, 2007, at 6:55 AM, Michał Niklas wrote:

> Alvaro Herrera wrote:
>> 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.
>>
>
>
> It is varchar.
>
> I'm sorry I didn't reported data structure. This table has many
> columns and indexes,
> and there is fragment of sql to create this table:
>
> create table "customers" (
> "id" serial,
> "customer" varchar(254) default '',
> -- other columns
> Constraint "customers_pkey" Primary Key ("id")
> );
>
> create index customer_idx on customers (customer);
> -- other indexes
>
> --
> Regards,
> Michal Niklas
> Poland
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that
> your
> message can get through to the mailing list cleanly

Douglas Toltzman
doug(at)oakstreetsoftware(dot)com
(910) 526-5938