pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedhow to make infinite intervals?
4+ messages / 3 participants
[nested] [flat]
* how to make infinite intervals?
@ 2006-03-03 17:01 Tilman Baumann <tilman.baumann@collax.com>
0 siblings, 2 replies; 4+ messages in thread
From: Tilman Baumann @ 2006-03-03 17:01 UTC (permalink / raw)
To: pgsql-sql
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. :)
Thank you
--
Tilman Baumann
Software Developer
Collax GmbH . Boetzinger Straß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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: how to make infinite intervals?
@ 2006-03-03 17:09 Tilman Baumann <tilman.baumann@collax.com>
parent: Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 0 replies; 4+ messages in thread
From: Tilman Baumann @ 2006-03-03 17:09 UTC (permalink / raw)
To: ; +Cc: pgsql-sql
Bruce Momjian schrieb:
>Tilman Baumann wrote:
>
>
>>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. :)
>>
>>
>
>On the TODO list:
>
> o Allow infinite dates and intervals just like infinite timestamps
>
>
Oh, i see.
Well, i can live without. :) Looking forward...
--
Tilman Baumann
Software Developer
Collax GmbH . Boetzinger Straß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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: how to make infinite intervals?
@ 2006-03-03 17:13 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Tilman Baumann <tilman.baumann@collax.com>
1 sibling, 1 reply; 4+ messages in thread
From: Bruce Momjian @ 2006-03-03 17:13 UTC (permalink / raw)
To: Tilman Baumann <tilman.baumann@collax.com>; +Cc: pgsql-sql
Tilman Baumann wrote:
> 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. :)
On the TODO list:
o Allow infinite dates and intervals just like infinite timestamps
--
Bruce Momjian http://candle.pha.pa.us
SRA OSS, Inc. http://www.sraoss.com
+ If your life is a hard drive, Christ can be your backup. +
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: how to make infinite intervals?
@ 2006-03-03 19:02 Tom Lane <tgl@sss.pgh.pa.us>
parent: Tilman Baumann <tilman.baumann@collax.com>
1 sibling, 0 replies; 4+ messages in thread
From: Tom Lane @ 2006-03-03 19:02 UTC (permalink / raw)
To: Tilman Baumann <tilman.baumann@collax.com>; +Cc: pgsql-sql
Tilman Baumann <tilman.baumann@collax.com> writes:
> I see there is a isfinite(interval) function.
Looks like it's just a stub :-(
Datum
interval_finite(PG_FUNCTION_ARGS)
{
PG_RETURN_BOOL(true);
}
Evidently someone planned for infinite intervals a long time ago,
but never got round to it.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2006-03-03 19:02 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-03-03 17:01 how to make infinite intervals? Tilman Baumann <tilman.baumann@collax.com>
2006-03-03 17:13 ` Bruce Momjian <pgman@candle.pha.pa.us>
2006-03-03 17:09 ` Tilman Baumann <tilman.baumann@collax.com>
2006-03-03 19:02 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox