detecting a NULL box - Mailing list pgsql-general

From dschmidt@lexmark.com
Subject detecting a NULL box
Date
Msg-id OF77E55C87.716A3ED1-ON85256DA6.0049F9D8@lexmark.com
Whole thread Raw
Responses Re: detecting a NULL box
List pgsql-general
Does anybody know how to detect a NULL in a geometric box type?

When I execute the following sql statement (coords is a box type)
autotest=# select coords from dlg_control limit 1
autotest-# \g
 coords
--------

(1 row)

So, I have data that contains a "NULL" in the coords column, but when I
test on box(NULL) I don't get any data...
autotest=# select coords from dlg_control where coords=box(NULL) limit 1
autotest-# \g
 coords
--------
(0 rows)

Any ideas?
Thanks,
Dennis





pgsql-general by date:

Previous
From: daisy_nhy@yahoo.com.hk (DN)
Date:
Subject: Question about connection java and Postgresql in Linux
Next
From: Tom Lane
Date:
Subject: Re: State of Beta 2