I think undefined is the exact result for that comparison, therefore the
returned error. False value will not be an error.
--
Jesus Aneiros Sosa
mailto:[EMAIL PROTECTED]
http://jagua.cfg.sld.cu/~aneiros
On Mon, 14 Aug 2000, Henry Lafleur wrote:
> Comparing anything = NULL (if it would work) wou
Use
select entry_id from tbl_date where date_02 is null;
NULL = NULL is undefined according to SQL standards.
--
Jesus Aneiros Sosa
mailto:[EMAIL PROTECTED]
http://jagua.cfg.sld.cu/~aneiros
On Mon, 14 Aug 2000, Web Manager wrote:
> ERROR: parser: parse error at or near "null"
> >select entry
Comparing anything = NULL (if it would work) would always false, at least
that's how other servers treat it. You have to use IS NULL.
select entry_id from tbl_date where date_02 IS NULL;
Henry
-Original Message-
From: Web Manager [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 14, 2000
Try
select entry_id from tbl_date where date_02 is NULL;
miguel sofer
>
>Hello,
>
>
>I have a problem with PostgreSQL when I try to select or delete an entry
>with an empty date. That's a typical entry
>
>Table tbl_date
>-
>entry_id154
>date_012000-01-15
>da
The syntax you're looking for is:
SELECT entry_id FROM tbl_date WHERE date_02 IS NULL;
Mark
Web Manager wrote:
>
> Hello,
>
> I have a problem with PostgreSQL when I try to select or delete an entry
> with an empty date. That's a typical entry
>
> Table tbl_date
> ---
Try:
select entry_id from tbl_date where date02 is null;
Kate
Web Manager wrote:
> Hello,
>
> I have a problem with PostgreSQL when I try to select or delete an entry
> with an empty date. That's a typical entry
>
> Table tbl_date
> -
> entry_id154
> date_01
