To: "Sim Zacks" <sim@compulab.co.il>, pgsql-sql@postgresql.org
Subject: Re: group by before and after date
References: <d0jkcf$28sb$1@news.hub.org>
Message-ID: <opsnmdu8cuth1vuj@localhost>
Date: Mon, 14 Mar 2005 09:58:10 +0100
From: PFC <lists@boutiquenumerique.com>
Organization: =?iso-8859-15?Q?La_Boutique_Num=E9rique?=
Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
In-Reply-To: <d0jkcf$28sb$1@news.hub.org>
User-Agent: Opera M2/7.54 (Linux, build 955)


> I have 2 tables 1 has a date field and component need by that date and  
> the
> other has all the upcoming orders.
> I am trying to build a query that will give me the Date and ComponentNeed
> and also how many components have been ordered before that date and how  
> many
> after.
> PostGreSQL is telling me I need to group on DatePromisedBy. I have tried  
> a
> number of different possibilities which haven't worked and now I have run
> into brain freeze. Any help would be appreciated.


	You could :
	SELECT ..., sum( stuff ), ..., (DatePromisedBy > a_particular_date) as  
after GROUP BY after

	You'll get two lines, one the sum of things before  a_particular_date,  
one of things after  a_particular_date. Look in the 'after' field to know  
which is which.