From: Roberto Mello <rmello@cc.usu.edu>
To: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Function overlaps_interval
Date: Thu, 12 Apr 2001 12:55:46 -0600
Message-ID: <20010412125546.A27735@cc.usu.edu> (raw)
In-Reply-To: <web-37366@davinci.ethosmedia.com>
References: <web-37366@davinci.ethosmedia.com>
On Thu, Apr 12, 2001 at 11:23:28AM -0700, Josh Berkus wrote:
> Folks,
>
> I wrote this PL/pgSQL function for my current project, and thought it
> would be generally useful. An expansion of the builtin
> overlaps(dt1,dt2,dt3,dt4) function, this function returns the interval
> of time for which the two datetime ranges overlap.
>
> Roberto, please include this in your online PL/pgSQL function library.
Done! Thanks Josh! Date/Time manipulation functions are now our most
popular category.
How about you? Do you have a (SQL|PL/pgSQL|PL/Perl|PL/Tcl|PL/Python)
function that you are proud of? A function that makes your life easier?
Then waste no more time! Point your browser to
http://www.brasileiro.net/postgres
submit your recipe and join the CookBook Hall of Fame! You get your
own awesome-cool "PostgreSQL Powered" button!
We've been getting many hits from techdocs.postgresql.org, which shows
that many are going to techdocs looking for solutions to common problems.
Very useful.
-Roberto
--
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+
Roberto Mello - Computer Science, USU - http://www.brasileiro.nethttp://www.sdl.usu.edu - Space Dynamics Lab, Developer
Bad command or file name. Go sit in corner.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: rmello@cc.usu.edu, josh@agliodbs.com
Subject: Re: Function overlaps_interval
In-Reply-To: <20010412125546.A27735@cc.usu.edu>
References: <web-37366@davinci.ethosmedia.com> <20010412125546.A27735@cc.usu.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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