From awais@techlogix.com Thu Mar  14 11:30:05 2002
Received: from gw1.lahore.techlogix.com (unknown [202.125.140.98])
	by postgresql.org (Postfix) with ESMTP id A6C844759A2
	for <pgsql-docs@postgresql.org>; Thu, 14 Mar 2002 06:30:05 -0500 (EST)
Received: from awais ([192.168.0.23])
	by gw1.lahore.techlogix.com (8.11.4/8.12.1) with SMTP id g2EBSR532067
	for <pgsql-docs@postgresql.org>; Thu, 14 Mar 2002 16:28:27 +0500
Message-ID: <009601c1cb4b$ed1b0040$1700a8c0@awais>
From: "awais" <awais@techlogix.com>
To: <pgsql-docs@postgresql.org>
Subject: problem with new postgresql driver
Date: Thu, 14 Mar 2002 16:32:30 +0500
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0093_01C1CB75.D5D9FDD0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
X-Archive-Number: 200203/34
X-Sequence-Number: 1315

This is a multi-part message in MIME format.

------=_NextPart_000_0093_01C1CB75.D5D9FDD0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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 mo=
re than 1) of "atm" table have this column value set as (null). When we exe=
cuted the query "select * from atm where location=3Dnull ", 0 rows were ret=
urned, which was not we were expecting.

    We have another database using previous driver of postgresql, it also h=
as a table named "atm" with a column named "location", similarly all record=
s (which are more than 1) of "atm" table have this column value set as (nul=
l), when we executed the query "select * from atm where location=3Dnull ", =
all rows were returned, which  was according to our expectations.

    Can u please describe how to tackle this problem.

regards,
Awais

------=_NextPart_000_0093_01C1CB75.D5D9FDD0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.3315.2870" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp; We have a table named "=
atm" in=20
our database which is uing latest driver of postgresql, it has a column nam=
ed=20
"location", all records (which are more than 1) of "atm"=20
table&nbsp;have&nbsp;this column value set as (null)</FONT><FONT face=3DAri=
al=20
size=3D2>. When we executed the query&nbsp;"</FONT><FONT face=3DArial size=
=3D2>select=20
* from atm where location=3Dnull "</FONT><FONT face=3DArial size=3D2>, 0=20
rows&nbsp;were returned, which was not we were expecting.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp; We have=20
another&nbsp;database&nbsp;using previous&nbsp;driver of postgresql,&nbsp;i=
t=20
also has a table named "atm" with&nbsp;a column named "location", similarly=
 all=20
records (which are more than 1) of "atm" table have&nbsp;this column value =
set=20
as (null)<FONT face=3DArial size=3D2>, when we executed the query&nbsp;"</F=
ONT><FONT=20
face=3DArial size=3D2>select * from atm where location=3Dnull "</FONT><FONT=
 face=3DArial=20
size=3D2>,&nbsp;all rows&nbsp;were returned, which&nbsp;</FONT>&nbsp;was ac=
cording=20
to our expectations.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp; Can u please describe h=
ow to=20
tackle this problem.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>regards,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Awais</FONT></DIV></BODY></HTML>

------=_NextPart_000_0093_01C1CB75.D5D9FDD0--




From reedstrm@rice.edu Fri Mar  15 23:14:19 2002
Received: from ece.rice.edu (ece.rice.edu [128.42.4.34])
	by postgresql.org (Postfix) with ESMTP id 1B67F47686C
	for <pgsql-docs@postgresql.org>; Fri, 15 Mar 2002 18:14:19 -0500 (EST)
Received: from localhost (localhost [127.0.0.1])
	by ece.rice.edu (Postfix) with ESMTP
	id F0C9468A5F; Fri, 15 Mar 2002 17:14:20 -0600 (CST)
Received: from wallace.ece.rice.edu (wallace.ece.rice.edu [128.42.12.154])
	by ece.rice.edu (Postfix) with ESMTP
	id 359C068A14; Fri, 15 Mar 2002 17:14:20 -0600 (CST)
Received: from reedstrm by wallace.ece.rice.edu with local (Exim 3.34 #1
	(Debian)) id 16m0tw-0004qZ-00; Fri, 15 Mar 2002 17:14:20 -0600
Date: Fri, 15 Mar 2002 17:14:19 -0600
From: "Ross J. Reedstrom" <reedstrm@rice.edu>
To: awais <awais@techlogix.com>
Cc: pgsql-docs@postgresql.org
Subject: Re: problem with new postgresql driver
Message-ID: <20020315231419.GB18407@rice.edu>
References: <009601c1cb4b$ed1b0040$1700a8c0@awais>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <009601c1cb4b$ed1b0040$1700a8c0@awais>
User-Agent: Mutt/1.3.27i
X-Virus-Scanned: by AMaViS snapshot-20010714
X-Archive-Number: 200203/35
X-Sequence-Number: 1316

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