Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 041DE650471
	for <pgsql-general-postgresql.org@mail.postgresql.org>;
	Fri, 21 Nov 2008 21:39:58 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 43797-01
	for <pgsql-general-postgresql.org@mail.postgresql.org>;
	Fri, 21 Nov 2008 21:39:54 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from nf-out-0910.google.com (nf-out-0910.google.com
 [64.233.182.184])
	by mail.postgresql.org (Postfix) with ESMTP id 876AC65046E
	for <pgsql-general@postgresql.org>;
	Fri, 21 Nov 2008 21:39:54 -0400 (AST)
Received: by nf-out-0910.google.com with SMTP id c7so714486nfi.23
	for <pgsql-general@postgresql.org>;
	Fri, 21 Nov 2008 17:39:52 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:mime-version:content-type;
	bh=TOqO5lDAPr3OLCySRYA00YfbTR2k+OamtllrQIUmHrY=;
	b=unMEYXdDgzlt2RZaJvKYziO0jB/vkalQaLXjhRMtrBYMUPKh9iyNSJDUtJ0kgElWez
	vmgtivHvX383UWq2491+As+dlx8aALL0mRIw5ouj4NCwBVRWGcTQkoN8b+AExvt0u8g4
	Aqhr2Z78awAuPIEMw4hWdTwFlvEM5pHjD/zI8=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:mime-version:content-type;
	b=pTYQQKJ3iftMOTXhYhnU5VzftAC+RCz06Z0FSfjOYpjlQSVkZYvxnHwGzkToIeNjC6
	kHiZzAo6fDSIlNME6wRcY/SsUU0+VFZUcQTQ4rVfZKJnBkuZxHUckJoaOWUHLT20gelc
	udJE/sIr/p+RXTbmMGf1HKLCnjb2VRo8lS8oU=
Received: by 10.210.58.13 with SMTP id g13mr1216591eba.60.1227317992774;
	Fri, 21 Nov 2008 17:39:52 -0800 (PST)
Received: by 10.210.111.17 with HTTP; Fri, 21 Nov 2008 17:39:52 -0800 (PST)
Message-ID: <98028b00811211739qb4a5e6bqf478bee397ea3596@mail.gmail.com>
Date: Fri, 21 Nov 2008 20:39:52 -0500
From: Zagato <zagato.gekko@gmail.com>
To: pgsql-general@postgresql.org
Subject: Interval Format
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_143409_15422148.1227317992763"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200811/1119
X-Sequence-Number: 140837

------=_Part_143409_15422148.1227317992763
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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 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 style of interval, i really need to see the day
part.... im using datestyle german in both.... im try with "SET
IntervalStyle TO..." but i get this error:
ERROR:  unrecognized configuration parameter "intervalstyle"
looking throw the forums i get that this new param its just for postgres
8.4...
So.. how can i recover my "days" part...

Any help it appreciate... thanks :D

Alan Jairo Acosta

-- 
Farewell.
http://www.youtube.com/zagatogekko
ruby << __EOF__
 puts [ 111, 116, 97, 103, 97, 90 ].collect{|v| v.chr}.join.reverse
__EOF__

------=_Part_143409_15422148.1227317992763
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi everyone... im looking for some help with the interval format between two diferents versions of postgres....<br>I have instaled in my old server postgres 8.0.3 and in my new one postgres <a href="http://8.3.5./" target="_blank">8.3.5.</a>..<br>

Everything in both looks works nice but i notice a little difference that is taking my crazy..<br>I have som SQL that in 8.0.3 do:<br># SELECT &#39;32 hours&#39;::INTERVAL;<br>&nbsp;&nbsp;&nbsp; interval<br>-----------------<br>&nbsp;@ 1 day 8 hours<br>

(1 row)<br><br>And in 8.3.5 do:<br>seg_veh2=# SELECT &#39;@ 32 hours&#39;::INTERVAL;<br>&nbsp; interval<br>------------<br>&nbsp;@ 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 day
part.... im using datestyle german in both.... im try with &quot;SET
IntervalStyle TO...&quot; but i get this error:<br>
ERROR:&nbsp; unrecognized configuration parameter &quot;intervalstyle&quot;<br>looking throw the forums i get that this new param its just for postgres 8.4...<br>So.. how can i recover my &quot;days&quot; part...<br><br>Any help it appreciate... thanks :D<br>

<br>Alan Jairo Acosta<br clear="all"><br>-- <br>Farewell.<br><a href="http://www.youtube.com/zagatogekko">http://www.youtube.com/zagatogekko</a><br>ruby &lt;&lt; __EOF__<br> &nbsp;puts [ 111, 116, 97, 103, 97, 90 ].collect{|v| v.chr}.join.reverse<br>
__EOF__<br>

------=_Part_143409_15422148.1227317992763--