Garry Saddington wrote: > Is there a way to make the following statement return the total of all effort. At the moment it gives a list of sum vs case. > > > select sum(effort), > CASE WHEN effortandattainment.effort=5 THEN -3 > WHEN effortandattainment.effort=4 THEN -2 > WHEN effortandattainment.effort=3 THEN 1 > WHEN effortandattainment.effort=2 THEN 2 > WHEN effortandattainment.effort=1 THEN 3 > > END > from effortandattainment SELECT sum(effort) FROM effortandattainment; But I'm guessing that's not what you mean. Can you show what output you'd like to have? -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
