X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id A8E799DC879
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  3 Mar 2006 13:17:07 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 10856-01
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  3 Mar 2006 13:17:06 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from mail.collax.com (mail.collax.com [213.164.67.137])
	by postgresql.org (Postfix) with ESMTP id 5947E9DC829
	for <pgsql-sql@postgresql.org>; Fri,  3 Mar 2006 13:17:05 -0400 (AST)
Received: from localhost (localhost [127.0.0.1])
	by localhost (Postfix) with ESMTP id 1A3F7298002
	for <pgsql-sql@postgresql.org>; Fri,  3 Mar 2006 18:17:02 +0100 (CET)
Received: from mail.collax.com (localhost [127.0.0.1])
	by localhost (AvMailGate-2.0.3-24) id 24225-386B0CED;
	Fri, 03 Mar 2006 18:17:01 +0100
Received: from [172.16.1.21] (unknown [172.16.1.21])
	by mail.collax.com (Postfix) with ESMTP id 4CFBB298002
	for <pgsql-sql@postgresql.org>; Fri,  3 Mar 2006 18:17:01 +0100 (CET)
Message-ID: <4408784B.3010209@collax.com>
Date: Fri, 03 Mar 2006 18:09:31 +0100
From: Tilman Baumann <tilman.baumann@collax.com>
User-Agent: Mozilla Thunderbird 1.0.7 (X11/20051017)
X-Accept-Language: de-DE, de, en-us, en
MIME-Version: 1.0
CC: pgsql-sql@postgresql.org
Subject: Re: how to make infinite intervals?
References: <200603031713.k23HDN528440@candle.pha.pa.us>
In-Reply-To: <200603031713.k23HDN528440@candle.pha.pa.us>
Content-Type: multipart/alternative;
	boundary="------------000905070003030708030208"
X-Filtered: By ProxSMTP
X-AntiVirus: checked by AntiVir MailGate (version: 2.0.3-24; AVE: 6.33.1.3;
	VDF: 6.33.1.60; host: mail)
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.246 required=5 tests=[AWL=0.056,
	HTML_MESSAGE=0.001, MISSING_HEADERS=0.189]
X-Spam-Score: 0.246
X-Spam-Level: 
X-Archive-Number: 200603/77
X-Sequence-Number: 24423

This is a multi-part message in MIME format.
--------------000905070003030708030208
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Bruce Momjian schrieb:

>Tilman Baumann wrote:
> =20
>
>>I see there is a isfinite(interval) function. So there must be somethin=
g
>>like a infinite interval.
>>
>>An infinite interval would be yuite handy for me at the moment. But i
>>have no clue how to make one.
>>
>>interval 'infinity' does not do the trick. :)
>>   =20
>>
>
>On the TODO list:
>
>   o Allow infinite dates and intervals just like infinite timestamps
> =20
>
Oh, i see.
Well, i can live without. :) Looking forward...

--=20
Tilman Baumann
Software Developer
Collax GmbH . Boetzinger Stra=DFe 60 . 79111 Freiburg . Germany

p: +49 (0) 761-4514-836
f: +49 (0) 761-4563-793

****** Meet us at CeBIT  ******
LinuxPark, Halle 5, Stand E64/6



--------------000905070003030708030208
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Bruce Momjian schrieb:
<blockquote cite="mid200603031713.k23HDN528440@candle.pha.pa.us"
 type="cite">
  <pre wrap="">Tilman Baumann wrote:
  </pre>
  <blockquote type="cite">
    <pre wrap="">I see there is a isfinite(interval) function. So there must be something
like a infinite interval.

An infinite interval would be yuite handy for me at the moment. But i
have no clue how to make one.

interval 'infinity' does not do the trick. :)
    </pre>
  </blockquote>
  <pre wrap=""><!---->
On the TODO list:

   o Allow infinite dates and intervals just like infinite timestamps
  </pre>
</blockquote>
Oh, i see.<br>
Well, i can live without. :) Looking forward...<br>
<br>
<pre class="moz-signature" cols="72">-- 
Tilman Baumann
Software Developer
Collax GmbH . Boetzinger Stra&szlig;e 60 . 79111 Freiburg . Germany

p: +49 (0) 761-4514-836
f: +49 (0) 761-4563-793

****** Meet us at CeBIT  ******
LinuxPark, Halle 5, Stand E64/6

</pre>
</body>
</html>

--------------000905070003030708030208--