From: | "Andrew C(dot)R(dot) Martin" <a(dot)c(dot)r(dot)martin(at)reading(dot)ac(dot)uk> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: GROUP BY / HAVING - am I being thick? |
Date: | 2000-04-13 15:52:12 |
Message-ID: | 00041316540301.04663@sapc13.rdg.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
> I have a question about GROUP BY / HAVING. It seems I can't do
> something I *think* I should be able to do!
[...]
> SELECT codon, sum(nexamples)
> FROM summary
> WHERE expl = 'f'
> GROUP BY codon
> HAVING expl = 'f';
OK! As I thought, I was being thick - helps to read the book properly instead
of dipping into it. Thanks Tom for clearing this up!
Andrew
--
Dr. Andrew C.R. Martin EMail: a(dot)c(dot)r(dot)martin(at)reading(dot)ac(dot)uk (work)
Lecturer in Bioinformatics andrew(at)stagleys(dot)demon(dot)co(dot)uk (home)
University of Reading
Tel.: +44 (0)118 987 5123x7022 Fax: +44 (0)118 931 0180
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Lockhart | 2000-04-13 16:43:01 | [Fwd: [HACKERS] Porting reports (cont'd)] |
Previous Message | Tom Lane | 2000-04-13 15:37:45 | Re: GROUP BY / HAVING - am I being thick? |