Re: How to retrieve rows with empty value in numeric(12,8) columns

From: Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to retrieve rows with empty value in numeric(12,8) columns
Date: 2011-12-06 10:53:24
Message-ID: 4EDDF424.1060009@orkash.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

select * from table where lat=NULL;

Above query also returns 0 rows.

Thanks
Bèrto ëd Sèra wrote:
> Hi,
>
> haven't checked this personally, but first of all... what if they are
> simply stored as NULLs?
>
> Bèrto
>
> On 6 December 2011 13:39, Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com
> <mailto:adarsh(dot)sharma(at)orkash(dot)com>> wrote:
>
> Dear all,
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adarsh Sharma 2011-12-06 11:00:30 Re: How to retrieve rows with empty value in numeric(12,8) columns
Previous Message Adarsh Sharma 2011-12-06 10:39:17 How to retrieve rows with empty value in numeric(12,8) columns