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--