| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | garry(at)schoolteachers(dot)co(dot)uk, PG-General Mailing List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: aggregates and case statements |
| Date: | 2008-11-17 13:58:51 |
| Message-ID: | 4921789B.1060301@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
garry(at)schoolteachers(dot)co(dot)uk wrote:
> Quoting Richard Huxton <dev(at)archonet(dot)com>:
>> But I'm guessing that's not what you mean. Can you show what output
>> you'd like to have?
>
> effort sum
> 1 245
> 2 463
> etc.
>
> Each value for effort has a different statistical meaning as in the case
> statement.
Sorry - still don't understand. The query you originally gave should
have provided the sum for each case (which you seem to be calling
"effort" here. I don't see where the problem is.
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Lanczos | 2008-11-17 14:12:41 | how to cite postgresql? |
| Previous Message | charlie derr | 2008-11-17 13:46:10 | List Ettiquette (perhaps Off Topic by now) was: Re: Database access over the Internet... |