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 [EMAIL PROTECTED] so that
your
message can get through to the mailing list cleanly
Douglas Toltzman
[EMAIL PROTECTED]
(910) 526-5938
