Re: [GENERAL] Interval Format

2008-11-21 Thread Zagato
Hi.. thanks for the answer well this work in the test sql, but this needs to rewrite all the SQL in my PHP application :-p Jejej... can i set a deatul time year in postgres.conf or with a single SET ... ? Thanks.. Alan Acosta On Fri, Nov 21, 2008 at 8:56 PM, Ron Mayer <[EMAIL PROTECTED]>wrot

Re: [GENERAL] Interval Format

2008-11-21 Thread Ron Mayer
Zagato wrote: I have som SQL that in 8.0.3 do: # SELECT '32 hours'::INTERVAL; interval - @ 1 day 8 hours And in 8.3.5 do: seg_veh2=# SELECT '@ 32 hours'::INTERVAL; interval @ 32 hours Why i unable to get my old style of interval, i really need to see the da

[GENERAL] Interval Format

2008-11-21 Thread Zagato
Hi everyone... im looking for some help with the interval format between two diferents versions of postgres I have instaled in my old server postgres 8.0.3 and in my new one postgres 8.3.5... Everything in both looks works nice but i notice a little difference that is taking my crazy.. I have s