Re: Converting file -Invalid data format on input DATE

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: Converting file -Invalid data format on input DATE
Дата
Msg-id 20041126150452.GA26221@wolff.to
обсуждение исходный текст
Ответ на Converting file -Invalid data format on input DATE  (Fred Wohlfert <fredwohlfert@ehbmail.com>)
Список pgsql-novice
On Tue, Nov 23, 2004 at 16:36:07 -0500,
  Fred Wohlfert <fredwohlfert@ehbmail.com> wrote:
> I am converting data from  dBaseIII format trying to load into Postgresql.
>
> I am having a problem with DATE field, the file I am working with does
> not have any data for
> this field on some records.  I have been fixing other problems with sed,
> however I am stumped with this.
>
> Will Postgresql take a null as input for a DATE field?

If you mean an empty string, no that isn't a valid date. You can store
SQL NULLs in a date column as long as you don't have any constraints that
would prohibit them.

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

Предыдущее
От: Aarni Ruuhimäki
Дата:
Сообщение: Querying a list field against another list
Следующее
От: Kjetil Haaland
Дата:
Сообщение: problem with memory allocation