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

Saluton,

On Wed, Aug 22, 2001 at 10:16:28AM +0200, Francois Thomas wrote:
>
> Hello everybody
>
> 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.