Re: NULL values for geometric type?

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: NULL values for geometric type?
Дата
Msg-id 20030612071106.Y25221-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на NULL values for geometric type?  ("Verhaag, G." <G.Verhaag@lrcb.umcn.nl>)
Список pgsql-general
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?



В списке pgsql-general по дате отправления:

Предыдущее
От: Richard Welty
Дата:
Сообщение: Re: Postgres performance comments from a MySQL user
Следующее
От: sector119@mail.ru
Дата:
Сообщение: tsearch - v2