From: Ross J. Reedstrom <reedstrm@rice.edu>
To: awais <awais@techlogix.com>
Cc: pgsql-docs@postgresql.org
Subject: Re: problem with new postgresql driver
Date: Fri, 15 Mar 2002 17:14:19 -0600
Message-ID: <20020315231419.GB18407@rice.edu> (raw)
In-Reply-To: <009601c1cb4b$ed1b0040$1700a8c0@awais>
References: <009601c1cb4b$ed1b0040$1700a8c0@awais>
The correct syntax is:
SELECT * FROM atm WHERE location IS NULL
Ross
On Thu, Mar 14, 2002 at 04:32:30PM +0500, awais wrote:
> Hi,
>
> We have a table named "atm" in our database which is uing latest driver of postgresql, it has a column named "location", all records (which are more than 1) of "atm" table have this column value set as (null). When we executed the query "select * from atm where location=null ", 0 rows were returned, which was not we were expecting.
>
> We have another database using previous driver of postgresql, it also has a table named "atm" with a column named "location", similarly all records (which are more than 1) of "atm" table have this column value set as (null), when we executed the query "select * from atm where location=null ", all rows were returned, which was according to our expectations.
>
> Can u please describe how to tackle this problem.
>
> regards,
> Awais
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: reedstrm@rice.edu, awais@techlogix.com
Subject: Re: problem with new postgresql driver
In-Reply-To: <20020315231419.GB18407@rice.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox