From: | Michał Niklas <michal(dot)niklas(at)heuthes(dot)pl> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Cc: | Michal Niklas <mn(at)heuthes(dot)pl> |
Subject: | Re: BUG #3493: Cannot find data with = operator |
Date: | 2007-07-27 10:55:56 |
Message-ID: | 46A9CF3C.3020603@heuthes.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Milen A. Radev | 2007-07-27 11:43:06 | Re: psql prompting for password. Can we suppress it? |
Previous Message | Sergey Burladyan | 2007-07-27 10:38:39 | BUG #3494: may be Query Error: subplan does not executed |