Re:

oss=> create table test (id box null);

oss=> insert into test values ('1,1,1,1');
INSERT 9697510 1
oss=> insert into test values (NULL);
INSERT 9697511 1
oss=> select * from test;
     id
-------------
 (1,1),(1,1)

(2 rows)

oss=> select * from test where id is not null;
     id
-------------
 (1,1),(1,1)
(1 row)

oss=> select version();
                           version
-------------------------------------------------------------
 PostgreSQL 7.3.2 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)

HTH
Darren


On Fri, 19 Sep 2003 dschmidt@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 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html
>

--
Darren Ferguson