Horton

Thread

  1. SELECT MAX question

    Jacob <jay@cob.com> — 2001-04-01T02:11:39Z

    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?



______________________________________________________________________
Posted Via Uncensored-News.Com - Still Only $9.95 - http://www.uncensored-news.com
   With Seven Servers In California And Texas - The Worlds Uncensored News Source

  2. Re: SELECT MAX question

    Eric G. Miller <egm2@jps.net> — 2001-04-01T05:56:50Z

    On Sat, Mar 31, 2001 at 09:11:39PM -0500, 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?

Think about what you're asking.  How can anything or anybody know
whether or not a NULL date is greater than some other date?  Maybe you
want to look into having a timestamp with a default of
CURRENT_TIMESTAMP?  

-- 
Eric G. Miller <egm2@jps.net>

  3. Re: SELECT MAX question

    ADBAAMD <adba.amdocs@bell.ca> — 2001-04-01T16:33:09Z

    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