RE: Bad timestamp external representation - Mailing list pgsql-novice

From Francois Thomas
Subject RE: Bad timestamp external representation
Date
Msg-id 28B4376D3C8AD411960300D0B73C48461F58EB@PROXY
Whole thread Raw
In response to Bad timestamp external representation  (Francois Thomas <FrancoisT@alsdesign.fr>)
List 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 by date:

Previous
From: "Albert REINER"
Date:
Subject: Re: Bad timestamp external representation
Next
From: Murray Hobbs
Date:
Subject: Re: protected ON DELETE CASCADE