age() and DateStyle ISO

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: age() and DateStyle ISO
Date: 2002-02-23 17:57:05
Message-ID: 3.0.6.32.20020223125705.0205a100@pop6.sympatico.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In an obscure part of my app that I haven't touched in many moons, I found
some code that contains:
SET DateStyle = 'ISO'
and then a SELECT age(timestamp,timestamp) from ...

In my php code I then tested
if ( strcmp( $row->age, "14 00:00" ) )
Sometime between 6.5.x [when the code was written] and 7.1 [current level]
the results from age() changed from "14 00:00" to "14 days"? I notice the
columns are now defined as 'timestamp with timezone' which was probably
automatic as part of one upgrade on another (they were simply 'timestamp'
in 6.5 as I recall).

Did the standard change? Was it never applicable to intervals?

Frank

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2002-02-23 18:43:33 Re: permissions
Previous Message tony 2002-02-23 17:36:18 Re: permissions