detecting a NULL box

[dschmidt]

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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Guy Fraser]

I don't know why you want to list a NULL with no other info, but here
you go:

SELECT coords FROM dlg_control WHERE coords IS NULL LIMIT 1;

ds******@lexmark.com wrote:

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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

--
Guy Fraser
Network Administrator
The Internet Centre
780-450-6787 , 1-888-450-6787

There is a fine line between genius and lunacy, fear not, walk the
line with pride. Not all things will end up as you wanted, but you
will certainly discover things the meek and timid will miss out on.

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match