Hi everyone... im looking for some help with the interval format between two diferents versions of postgres....<br />I
haveinstaled in my old server postgres 8.0.3 and in my new one postgres <a href="http://8.3.5.">8.3.5.</a>..<br />
Everythingin both looks works nice but i notice a little difference that is taking my crazy..<br />I have som SQL that
in8.0.3 do:<br /># SELECT '32 hours'::INTERVAL;<br /> interval<br />-----------------<br /> @ 1 day 8 hours<br /> (1
row)<br/><br />And in 8.3.5 do:<br />seg_veh2=# SELECT '@ 32 hours'::INTERVAL;<br /> interval<br />------------<br
/> @32 hours<br />(1 row)<br /><br clear="all" />Why i unable to get my old style of interval, i really need to see the
daypart.... im using datestyle german in both.... im try with "SET IntervalStyle TO..." but i get this error:<br />
ERROR: unrecognized configuration parameter "intervalstyle"<br />looking throw the forums i get that this new param its
justfor postgres 8.4...<br />So.. how can i recover my "days" part...<br /><br />Any help it appreciate... thanks :D<br
/><br/>Alan Jairo Acosta<br /><br />