Обсуждение: NULL values for geometric type?

Dear list-member,

Am I right in saying that geometric types like POINT, BOX,CIRCLE do not accept NULL values? I receive the following
message:ERROR:  copy: line 1, Bad box external representation 'NULL', when trying just that! 

Regards,
    Geert Verhaag

National Expert and Training Centre for Breast Cancer Screening (LRCB)
UMC St. Radboud / UMC Nijmegen
451, LRCB
P.O. Box 9101, 6500 HB Nijmegen, Netherlands
Tel: +31.24.36(17551/16706)
E-mail: g.verhaag@lrcb.umcn.nl

On Thu, 12 Jun 2003, Verhaag, G. wrote:

> Dear list-member,
>
> Am I right in saying that geometric types like POINT, BOX,CIRCLE do
> not accept NULL values? I receive the following message: ERROR:
> copy: line 1, Bad box external representation 'NULL', when trying just
> that!

It looks like you're probably trying to insert the text NULL rather than a
NULL into the column.  I can insert a NULL with insert or in a copy if I
use the correct nullstring (you can set what is read as a null with a NULL
[ AS ] 'nullstring' option to copy.  Can you give a full example of what
you were trying?