From: dschmidt(at)lexmark(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject:
Date: 2003-09-19 15:34:17
Message-ID: OFAC730F9E.99299A34-ON85256DA6.005576B8@lexmark.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

  • Re: at 2003-09-19 16:01:03 from Stephan Szabo
  • Re: at 2003-09-19 16:06:01 from darren
  • Re: at 2003-09-19 16:58:20 from Doug McNaught

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-09-19 15:34:34 Re: Trouble with some concepts
Previous Message Richard Huxton 2003-09-19 15:27:36 Re: Column defaults fail with rules on view