Re: Question about Encoding a Custom Type - Mailing list pgsql-hackers

"David E. Wheeler" <david@kineticode.com> writes:
> Now I have just one more bizarre error: PostgreSQL thinks that a  
> citext column is not in an aggregate even when it is:
> try=# select array_accum(name) from srt order by name;
> ERROR:  column "srt.name" must appear in the GROUP BY clause or be  
> used in an aggregate function

> Um, what?

It's complaining about the use in ORDER BY.
        regards, tom lane