Skip site navigation (1)
Skip section navigation (2)
I need to Group By a date column that may contain a NULL value. Min() only gives me the lowest date and not NULL if it exists. How do I get a Group By clause to give me NULL if it exists?
Peripheral Links
Header And Logo
|
Site Navigation
Group By, Aggregate Functions and NULL
- From: Brendon Gleeson <brendon(at)gleesonprop(dot)co(dot)za>
- To: pgsql-novice(at)postgresql(dot)org
- Subject: Group By, Aggregate Functions and NULL
- Date: Thu, 27 Jul 2006 19:25:10 +0200
I need to Group By a date column that may contain a NULL value. Min() only gives me the lowest date and not NULL if it exists. How do I get a Group By clause to give me NULL if it exists?
- Follow-Ups:
- Re: Group By, Aggregate Functions and NULL
- From: Andrew Hammond
- Re: Group By, Aggregate Functions and NULL
- Prev by Date: Re: pg_dump ordering in 8.1.3
- Next by Date: Re: Group By, Aggregate Functions and NULL
- Previous by thread: pg_dump ordering in 8.1.3
- Next by thread: Re: Group By, Aggregate Functions and NULL
- Indexes: