Re: select an entry with a NULL date field - Mailing list pgsql-sql

Use

select entry_id from tbl_date where date_02 is null;

NULL = NULL is undefined according to SQL standards.

--
Jesus Aneiros Sosa
mailto:aneiros@jagua.cfg.sld.cu
http://jagua.cfg.sld.cu/~aneiros

On Mon, 14 Aug 2000, Web Manager wrote:

> ERROR:  parser: parse error at or near "null"
> >select entry_id from tbl_date where date_02='';
> Not work, that's a wrong date format
> >select entry_id from tbl_date where date_02="";
> Not work, "" considered as an attribute
> 
> Thank you for your time!
> -- 
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Marc Andre Paquin
>