[SQL] 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

Re: [SQL] Interval Format

2008-11-21 Thread Tom Lane
Zagato [EMAIL PROTECTED] writes: I have som SQL that in 8.0.3 do: # SELECT '32 hours'::INTERVAL; interval - @ 1 day 8 hours (1 row) And in 8.3.5 do: seg_veh2=# SELECT '@ 32 hours'::INTERVAL; interval @ 32 hours (1 row) Why i unable to get my old

Re: [SQL] Interval Format

2008-11-21 Thread Zagato
Hi this seems to works... but this will need to rewrite all my sql inPHP that uses interval can i make this default in postgres.conf or something similar... Thanks... Alan Jairo Acosta On Fri, Nov 21, 2008 at 9:15 PM, Tom Lane [EMAIL PROTECTED] wrote: Zagato [EMAIL PROTECTED] writes: