The schema specification you provided doesn't even include the column=20=20
"name", which you are selecting in your original message. What is=20=20
the field type of "name" ?
On Jul 27, 2007, at 6:55 AM, Micha=C5=82 Niklas wrote:
> Alvaro Herrera wrote:
>> Michal Niklas wrote:
>>
>>
>>> isof_customer=3D# insert into customers (name) values ('KIOSK ');
>>> INSERT 437819002 1
>>> isof_customer=3D# select id,name from customers where name=3D'KIOSK ';
>>> id | name
>>> ---------------+------------------
>>> (0 rows)
>>>
>>> isof_customer=3D# select id,name from customers where name like=20=20
>>> '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=20=20
> 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
>
> --=20
> Regards,
> Michal Niklas
> Poland
>
>
> ---------------------------(end of=20=20
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that=20=20
> your
> message can get through to the mailing list cleanly
Douglas Toltzman
doug@oakstreetsoftware.com
(910) 526-5938