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]> writ

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

[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 s