RE: SELECT MAX question

Yes. Its COALESCE(). Example:

SELECT COALESCE(NULL, 'Mike');
  case
________
 Mike
(1 row)

Hope that helps,

Mike Mascari
mascarm@mascari.com

-----Original Message-----
From:    ADBAAMD [SMTP:adba.amdocs@bell.ca]
Sent:    Sunday, April 01, 2001 12:33 PM
To:    Jacob
Cc:    pgsql-general@postgresql.org
Subject:    Re: [GENERAL] SELECT MAX question

Jacob wrote:

> I have an sql tatement in my ASP page that has a WHERE date = (SELECT
> MAX(other_date) FROM SomeTable WHERE Blah1 = Blah2) clause.  What's
> happening is that the query is grabbing the latest date ONLY if something
> something is in the "other_date" field.  If the "other_date" field is blank,
> then the record is not chosen.  My question is, how do I grab the latest
> date of "other_date" even if the it happens to be blank?

    Adding my own question to this, does pgsql have an equivalent to the
Oracle NVL function?