Re: Interval Format

Hi.... this seems to works... but this will need to rewrite all my sql inPHP that uses interval.... can i make this
defaultin postgres.conf or something similar...<br /><br />Thanks...<br /><br />Alan Jairo Acosta<br /><br /><div
class="gmail_quote">On Fri, Nov 21, 2008 at 9:15 PM, Tom Lane <span dir="ltr"><<a
href="mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>></span>wrote:<br /><blockquote class="gmail_quote"
style="border-left:1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div
class="Ih2E3d">Zagato<<a href="mailto:zagato.gekko@gmail.com">zagato.gekko@gmail.com</a>> writes:<br /> > I
havesom SQL that in 8.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 /> > Why i unable to get my old style of interval,<br /><br /></div>Because '1 day' isn't really the
samething as '24 hours', at least not<br /> if you live anywhere that they have daylight savings time.<br /><br /> You
canprobably get the behavior you want by passing the value through<br /> justify_hours(), which does the conversion
assuming1 day == 24 hours.<br /><br />                        regards, tom lane<br /></blockquote></div><br /><br
clear="all"/><br />