Message-ID: <4665537A.2060601@archonet.com>
Date: Tue, 05 Jun 2007 13:13:46 +0100
From: Richard Huxton <dev@archonet.com>
User-Agent: Thunderbird 2.0.0.0 (X11/20070326)
MIME-Version: 1.0
To: Loredana Curugiu <loredana.curugiu@gmail.com>
Cc: pgsql-novice@postgresql.org, pgsql-sql@postgresql.org
Subject: Re: JOIN
References: <1c23c8e70706050111i5ba672d6j78bd9afa4b786616@mail.gmail.com>
	<1c23c8e70706050426y12d567ban70ffdafb75808e0e@mail.gmail.com>
In-Reply-To: <1c23c8e70706050426y12d567ban70ffdafb75808e0e@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Loredana Curugiu wrote:
> Any help, please?


>> So  I have the following query:
>>
>>        SELECT SUM(A.count),
>>                      A.theme,
>>                      A.receiver,
>>                      A.dates
>>           FROM my_table A
>> INNER JOIN my_table B
>>               ON A.theme=B.theme
>>             AND A.receiver=B.receiver
>>             AND A.date=ANY(B.dates)
>>  GROUP BY A.theme,A.receiver, A.dates;
[snip]
>>
>> The result is wrong. I don't know what it is wrong at my query.
>> Please help.

You don't actually say what's wrong. What are you expecting as output?

Oh, and your "date" column isn't - it's a timestamp with time-zone. That 
might or might not cause confusion with daylight-saving-times.

-- 
   Richard Huxton
   Archonet Ltd