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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-sql by date

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