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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-03-21 00:24:33 | Use of SGML vs. LaTeX |
Previous Message | awais | 2002-03-14 11:32:30 | problem with new postgresql driver |