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

[Douglas Toltzman <doug(at)oakstreetsoftware(dot)com>]

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