Re: SELECT MAX question - Mailing list pgsql-general

From ADBAAMD
Subject Re: SELECT MAX question
Date
Msg-id 3AC75845.3090604@bell.ca
Whole thread Raw
In response to SELECT MAX question  ("Jacob" <Jay@cob.com>)
List pgsql-general
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?



--
  _
/ \   Leandro Guimarães Faria Corsetti Dutra         +55 (11) 3040 8913
\ /   Amdocs at Bell Canada                          +1 (514) 786 87 47
  X    Support Center, São Paulo, Brazil          mailto:adbaamd@bell.ca
/ \   http://terravista.pt./Enseada/1989/    mailto:leandrod@amdocs.com



pgsql-general by date:

Previous
From: Daniel ?erud
Date:
Subject: Re: Re: Dissapearing indexes, what's that all about?
Next
From: Mike Mascari
Date:
Subject: RE: Re: Dissapearing indexes, what's that all about?