Re: Multiple columns w/single aggregate

> I cannot successfully execute the sql statement:
>
> SELECT percentage, MAX(start_date) FROM sometable
> WHERE id = 1

Sure, you need GROUP BY. How does it know which columns to use for the
MAX.

>
> I get the error message:
>
> ERROR: Attribute sometable.percentage must be GROUPed
> or used in an aggregate function
>
> I know that I have seen examples of selecting multiple columns with a
> single colunn aggregate function. In fact, the new 'PostgreSQL:
> Introductions and Concepts' book by Bruce Momjian has two on page 53.
> Does anyone know why this doesn't work?
>
> Thanks in advance.
>
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026