Skip site navigation (1) Skip section navigation (2)

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

From: Douglas Toltzman <doug(at)oakstreetsoftware(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3493: Cannot find data with = operator
Date: 2007-07-27 14:10:50
Message-ID: 0292D49F-C248-49A9-AF81-1A9CCAC61DFA@oakstreetsoftware.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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



In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2007-07-28 15:06:28
Subject: Re: BUG #3494: may be Query Error: subplan does not executed
Previous:From: Heikki LinnakangasDate: 2007-07-27 13:58:20
Subject: Re: BUG #3494: may be Query Error: subplan does not executed

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group