"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