Received: from localhost (unknown [200.46.204.184])
	by developer.postgresql.org (Postfix) with ESMTP id 3487F2E0031
	for <pgsql-admin-postgresql.org@developer.postgresql.org>;
	Mon, 12 May 2008 12:01:46 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 61130-06
	for <pgsql-admin-postgresql.org@developer.postgresql.org>;
	Mon, 12 May 2008 12:01:42 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from smadev.internal.net (host3.dynacom.ondsl.gr [62.103.35.211])
	by developer.postgresql.org (Postfix) with ESMTP id 029C62E004A
	for <pgsql-admin@postgresql.org>; Mon, 12 May 2008 12:01:39 -0300 (ADT)
Received: from smadev.internal.net (localhost [127.0.0.1])
	by smadev.internal.net (8.14.2/8.14.2) with ESMTP id m4CF1a0a092757;
	Mon, 12 May 2008 18:01:36 +0300 (EEST)
	(envelope-from achill@matrix.gatewaynet.com)
Received: from localhost (localhost [[UNIX: localhost]])
	by smadev.internal.net (8.14.2/8.14.2/Submit) id m4CF1Zci092756;
	Mon, 12 May 2008 18:01:35 +0300 (EEST)
	(envelope-from achill@matrix.gatewaynet.com)
From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Organization: Dynacom Tankers Mgmt
To: Julius Tuskenis <julius@nsoft.lt>, pgsql-admin@postgresql.org
Subject: Re: how to get a number of seconds in some interval ?
Date: Mon, 12 May 2008 18:01:34 +0300
User-Agent: KMail/1.9.7
References: <482849B0.6050103@nsoft.lt>
	<200805121724.38772.achill@matrix.gatewaynet.com>
	<48285507.4010007@nsoft.lt>
In-Reply-To: <48285507.4010007@nsoft.lt>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200805121801.35101.achill@matrix.gatewaynet.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200805/94
X-Sequence-Number: 29178

=CE=A3=CF=84=CE=B9=CF=82 Monday 12 May 2008 17:32:39 =CE=BF/=CE=B7 Julius T=
uskenis =CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5:
> Thank you, Achilleas.
>=20
> do you know why division of intervals was not implemented? As I see it -=
=20
> there should be an easy way to do so. '1 hour 30 minutes' / '1 hour' =3D=
=20
> 1.5 .... Seems straight forward...
>=20
No idea why. However as you pose it,it makes sense.
>=20
> Achilleas Mantzios ra=C5=A1=C4=97:
> > =CE=A3=CF=84=CE=B9=CF=82 Monday 12 May 2008 16:44:16 =CE=BF/=CE=B7 Juli=
us Tuskenis =CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5:
> >  =20
> >> Hello,
> >>
> >> Is there a good method of knowing how mutch seconds does some interval=
=20
> >> have?? I tried my_interval / (interval '1 second'), but there is no=20
> >> operator interval / interval defines (I wonder why).
> >> Is there a method to do so?
> >>
> >>    =20
> > smth like
> > dynacom=3D# SELECT extract(epoch from '49 hours 0 mins 12 seconds'::int=
erval);
> >
> >  =20
> >> --=20
> >> Julius Tuskenis
> >> Programavimo skyriaus vadovas
> >> UAB nSoft
> >> mob. +37068233050
> >>
> >>
> >>    =20
> >
> >
> >
> >  =20
>=20
>=20



=2D-=20
Achilleas Mantzios