| From: | "Jacob" <Jay(at)cob(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | SELECT MAX question |
| Date: | 2001-04-01 02:11:39 |
| Message-ID: | 3ac68e33_3@news.uncensored-news.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Justin Clift | 2001-04-01 03:13:21 | Need PostgreSQL startup scripts |
| Previous Message | Bruce Momjian | 2001-04-01 00:58:17 | Re: Re: [SQL] Re: pg_dump potential bug -UNIQUE INDEX on PG_SHADOW Dont!! HELP |