RE: Bad timestamp external representation

Поиск
Список
Период
Сортировка
От Francois Thomas
Тема RE: Bad timestamp external representation
Дата
Msg-id 28B4376D3C8AD411960300D0B73C48461F58EB@PROXY
обсуждение исходный текст
Ответ на Bad timestamp external representation  (Francois Thomas <FrancoisT@alsdesign.fr>)
Список pgsql-novice


> > I meet the "bad timestamp external representation" error,
> and I don't know
> ...
> > SELECT equip,produit,nserie,exserie,ech FROM package
> > union
> > SELECT id,produit,nserie,exserie,ech FROM equip
> > union
> > SELECT equip_id,'',produit,'','' FROM cles
>                                 ^^
>
> This looks to me that you are trying to use '' as a
> timestamp. Instead, you should provide a meaningful timestamp -
> probably NULL ("don't know").
>
> Albert.

Many thanks to all the persons who helped me with this issue !
The view is now working perfectly...
Salutations from France
François Thomas

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

Предыдущее
От: "Albert REINER"
Дата:
Сообщение: Re: Bad timestamp external representation
Следующее
От: Murray Hobbs
Дата:
Сообщение: Re: protected ON DELETE CASCADE