Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group