pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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.net 
       http://www.sdl.usu.edu - Space Dynamics Lab, Developer    
Bad command or file name. Go sit in corner.



view thread (2+ messages)

Message-ID: <20010412125546.A27735@cc.usu.edu>
Permalink:  ../20010412125546.A27735@cc.usu.edu/
Also on:    postgresql.org/message-id/20010412125546.A27735@cc.usu.edu

 · 

reply

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