X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 220F732A1AA
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  6 Oct 2004 06:52:04 +0100 (BST)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 76494-08
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  6 Oct 2004 05:52:01 +0000 (GMT)
Received: from rock.spider.ru (rock.spider.ru [62.183.34.226])
	by svr1.postgresql.org (Postfix) with ESMTP id D94CF32A155
	for <pgsql-sql@postgresql.org>; Wed,  6 Oct 2004 06:52:00 +0100 (BST)
Received: from rock (localhost [127.0.0.1]) by rock (Postfix) with SMTP
	id DF19A2B2F4; Wed,  6 Oct 2004 09:51:57 +0400 (MSD)
Received: from sad.localnet.ru (sad.localnet.ru [10.0.0.72])
	by rock.spider.ru (Postfix) with ESMTP
	id C47452B2EF; Wed,  6 Oct 2004 09:51:56 +0400 (MSD)
Content-Type: text/plain;
  charset="iso-8859-1"
From: sad <sad@bankir.ru>
Organization: IT
To: Erik Wasser <erik.wasser@iquer.net>, pgsql-sql@postgresql.org
Subject: Re: Howto turn an integer into an interval?
Date: Wed, 6 Oct 2004 09:01:42 +0400
User-Agent: KMail/1.4.3
References: <200410051407.42037.erik.wasser@iquer.net>
In-Reply-To: <200410051407.42037.erik.wasser@iquer.net>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200410060901.42334.sad@bankir.ru>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200410/38
X-Sequence-Number: 19141

hello

SELECT ('3600'::int::abstime-'epoch'::abstime)::interval;

try to modify this idea to fit your purpose.