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

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

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Michal Niklas <mn(at)heuthes(dot)pl>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3493: Cannot find data with = operator
Date: 2007-07-27 10:35:49
Message-ID: 20070727103549.GA3572@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Responses

pgsql-bugs by date

Next:From: Sergey BurladyanDate: 2007-07-27 10:38:39
Subject: BUG #3494: may be Query Error: subplan does not executed
Previous:From: Pradeep RaiDate: 2007-07-27 10:18:33
Subject: psql prompting for password. Can we suppress it?

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