From: | Ennio-Sr <nasr(dot)laili(at)tin(dot)it> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: How to get single raws for sums in a summary table? |
Date: | 2006-11-22 19:22:15 |
Message-ID: | 20061122192215.GA6425@deby.ei.hnet |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
* Richard Broersma Jr <rabroersma(at)yahoo(dot)com> [221106, 06:53]:
> Oops I tested this and didn't get what you wanted. try this instead.
>
> >
> > This is untested. Also I am not sure that this is what you want, but I do not know how you
> > arrive
> > at the values in your summary table.
> >
> > select
> > distinct on (titolo)
> ^^^^^^
> ...
>
> Regards,
> Richard Broersma Jr.
Hi Richard (and others),
I was cheering too early in my previous answer ;)
The query is only apparently giving a sum: in effect the value in each
raw is just one of the values of raws having the same 'titolo'.
What I had in mind was the possibility to achieve the same result I used
to get (quite a few years back) in DBIII, when printing data and setting
subtotals for same items. But this is history ......
Anyway, thanks again for attention and help.
Regards,
Ennio.
--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?//
Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (°|°)
[Why use Win$ozz (I say) if ... "even a fool can do that. )=(
Do something you aren't good at!" (as Henry Miller used to say) ]
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Broersma Jr | 2006-11-22 20:06:01 | Re: How to get single raws for sums in a summary table? |
Previous Message | Ennio-Sr | 2006-11-22 17:31:30 | Re: How to get single raws for sums in a summary table? |