pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  

help / color / mirror / Atom feed

problem with new postgresql driver
2+ messages / 2 participants
[nested] [flat]

* problem with new postgresql driver
@ 2002-03-14 11:32 awais <awais@techlogix.com>
  2002-03-15 23:14 ` Re: problem with new postgresql driver Ross J. Reedstrom <reedstrm@rice.edu>
  0 siblings, 1 reply; 2+ messages in thread

From: awais @ 2002-03-14 11:32 UTC (permalink / raw)
  To: pgsql-docs

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

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: problem with new postgresql driver
  2002-03-14 11:32 problem with new postgresql driver awais <awais@techlogix.com>
@ 2002-03-15 23:14 ` Ross J. Reedstrom <reedstrm@rice.edu>
  0 siblings, 0 replies; 2+ messages in thread

From: Ross J. Reedstrom @ 2002-03-15 23:14 UTC (permalink / raw)
  To: awais <awais@techlogix.com>; +Cc: 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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2002-03-15 23:14 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-03-14 11:32 problem with new postgresql driver awais <awais@techlogix.com>
2002-03-15 23:14 ` Ross J. Reedstrom <reedstrm@rice.edu>

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