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?