- Mailing list pgsql-general

From dschmidt@lexmark.com
Subject
Date
Msg-id OFAC730F9E.99299A34-ON85256DA6.005576B8@lexmark.com
Whole thread Raw
Responses Re:  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Re:  (darren@crystalballinc.com)
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:
Date:
Subject: Re: Column defaults fail with rules on view
Next
From: Tom Lane
Date:
Subject: Re: Column defaults fail with rules on view