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

Re: problem with new postgresql driver

From: "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>
To: awais <awais(at)techlogix(dot)com>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: problem with new postgresql driver
Date: 2002-03-15 23:14:19
Message-ID: 20020315231419.GB18407@rice.edu (view raw or flat)
Thread:
Lists: pgsql-docs
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

In response to

pgsql-docs by date

Next:From: Bruce MomjianDate: 2002-03-21 00:24:33
Subject: Use of SGML vs. LaTeX
Previous:From: awaisDate: 2002-03-14 11:32:30
Subject: problem with new postgresql driver

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