DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID;
	b=cBZnU4786uPCvEVtSA3vytssS+oPVHwu5KjrsL5e47LMISPU+653j71OUJlxv/qFoO8LyaFgLEeznKOzRKRbMyvM0ndjOpgqDv6jJXuZb50LO40nNgmJwqOeaHw8jtJCfMNGNE1mdflWGERmjMEqDSmr3/lkPx87aXv8JiPijbQ=
	;
Date: Tue, 31 Oct 2006 21:51:12 -0800 (PST)
From: Richard Broersma Jr <rabroersma@yahoo.com>
Subject: Re: Add calculated fields from one table to other table
To: roopa perumalraja <roopabenzer@yahoo.com>, pgsql-sql@postgresql.org
In-Reply-To: <20061101035440.76569.qmail@web50809.mail.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Message-ID: <50323.50500.qm@web31808.mail.mud.yahoo.com>

> Hi Richard,
>    
>   Thanks a lot. I still am not able to get the result for all the rics in the ticks table but I
> am able to get the result for a particular ric.
>    
>   Can you help me with getting the result for all the rics in the ticks table
>    
>   Thanks
>   Roopa

Could you send create table statements for the tables you are working on, and a few insert
statements for each table to have sample data. then show what you want the query results to look
like.

But from what you stated in your previous emails here is what I gather: maybe it might work?

select    tk.ric as ric, 
          tm.times_time as minute, --timestamps by minutes
          count(tk.*) as ,
          ...
from      times tm
left join ticks tk
on (tm.times_time = date_trunc('minutes', tk.time))
group by  ric, minute
order by  minute;