| 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: | Whole Thread | Raw Message | 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
| 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 |