RE: Bad timestamp external representation

From: Francois Thomas <FrancoisT(at)alsdesign(dot)fr>
To: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: RE: Bad timestamp external representation
Date: 2001-08-23 16:24:01
Message-ID: 28B4376D3C8AD411960300D0B73C48461F58EB@PROXY
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-novice by date

  From Date Subject
Next Message Charles Voss 2001-08-23 16:58:24 PostgreSQL connection
Previous Message Gregory Wood 2001-08-23 14:48:19 Re: protected ON DELETE CASCADE