Thread

1. '13 months ago'::reltime

   Albert REINER <areiner@tph.tuwien.ac.at> — 2001-05-01T12:36:43Z

   Saluton,
   
   I do not quite understand the following:
   
   ,----
   | albert=> select '13 months ago'::reltime;
   | 	?column?
   | ---------------------
   |  1 year 25 00:00 ago
   | (1 row)
   | 
   | albert=> select '13 months ago'::interval;
   | 	  ?column?
   | ------------------------
   |  1 year 1 mon 00:00 ago
   | (1 row)
   | 
   | albert=> select version();
   | 				version
   | --------------------------------------------------------------------
   |  PostgreSQL 7.0.2 on i586-pc-linux-gnulibc1, compiled by gcc 2.95.1
   | (1 row)
   `----
   
   Shouldn't 13 months be 1 year and 1 month even for reltime?
   
   Somewhat puzzled,
   
   Albert.
   
   
   

2. Re: '13 months ago'::reltime

   Tom Lane <tgl@sss.pgh.pa.us> — 2001-05-03T18:32:56Z

   Type reltime is old and deprecated.  Don't use it.
   
   			regards, tom lane
   
   

3. Re: '13 months ago'::reltime

   Christopher Sawtell <csawtell@xtra.co.nz> — 2001-05-05T06:58:50Z

   On Friday 04 May 2001 06:32, you wrote:
   > Type reltime is old and deprecated.  Don't use it.
   
   What should we be using instead?
   
   -- 
   Sincerely etc.,
   
    NAME       Christopher Sawtell
    CELL PHONE 021 257 4451
    ICQ UIN    45863470
    EMAIL      csawtell @ xtra . co . nz
    CNOTES     ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz
   
    -->> Please refrain from using HTML or WORD attachments in e-mails to me <<--
   
   
   

4. Re: '13 months ago'::reltime

   Peter Eisentraut <peter_e@gmx.net> — 2001-05-05T12:55:46Z

   Christopher Sawtell writes:
   
   > On Friday 04 May 2001 06:32, you wrote:
   > > Type reltime is old and deprecated.  Don't use it.
   >
   > What should we be using instead?
   
   interval
   
   -- 
   Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter