ODBC SELECT WHERE a IN ('frob') returns where a = '' too

From: Adam Haberlach <adam(at)newsnipple(dot)com>
To: bugs(at)postgresql(dot)org
Subject: ODBC SELECT WHERE a IN ('frob') returns where a = '' too
Date: 2000-05-23 05:31:49
Message-ID: 20000522223149.A24184@ricochet.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

==========================================================================
POSTGRESQL BUG REPORT TEMPLATE
==========================================================================

Your name : Adam Haberlach
Your email address : adam(at)be(dot)com

System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel Pentium

Operating System (example: Linux 2.0.26 ELF) :Linux version 2.2.2

PostgreSQL version (example: PostgreSQL-6.5.1): PostgreSQL-7.0

Compiler used (example: gcc 2.8.0) : gcc version 2.7.2.3

Please enter a FULL description of your problem:
------------------------------------------------

When I do a query of the form

SELECT a FROM tbl WHERE a IN ('frob');

where a is an indexed text field containing 'frob', 'dingus', '', and
NULL

I get a set that includes rows both where
a == 'frob'
a == ''

This happens when I use ODBC from Microsoft Access's pass-through, but
does not seem to happen from the psql
command-line. This seems to confuse my coworker who is more familiar
with non-Postgres databases then I.

--
Adam Haberlach |"You have to understand that the
adam(at)newsnipple(dot)com | entire 'Net is based on people with
http://www.newsnipple.com/ | too much free time on their hands."

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2000-05-23 05:33:56 Re: ODBC SELECT WHERE a IN ('frob') returns where a = '' too
Previous Message Adam Haberlach 2000-05-23 05:29:57 pg_dump crashes trying to dump database containing index on oid