Skip site navigation (1) Skip section navigation (2)

Re: JOIN performance

From: Chester Kustarz <chester(at)arbor(dot)net>
To: "Dean Gibson (DB Administrator)" <postgresql3(at)ultimeth(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: JOIN performance
Date: 2004-09-21 04:09:19
Message-ID: Pine.BSO.4.44.0409210008260.17616-100000@detroit.arbor.net (view raw or flat)
Thread:
Lists: pgsql-sql
On Mon, 20 Sep 2004, Dean Gibson (DB Administrator) wrote:
> Okay, now for my big question:  I searched high and low for a function that
> would return the minimum of two dates, and found none.  Now you come up
> with "date_smaller", which works fine (as does "date_larger"), but where
> are those documented?  More importantly, where are other functions like
> them documented?

You can make them:

http://www.postgresql.org/docs/7.4/interactive/server-programming.html

"strict" means it will return NULL when the input is NULL.



In response to

pgsql-sql by date

Next:From: Tom LaneDate: 2004-09-21 04:10:13
Subject: Re: JOIN performance
Previous:From: Dean Gibson (DB Administrator)Date: 2004-09-21 01:41:33
Subject: Re: JOIN performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group