Andrew Gould wrote:
> Once it gets cleaned up a little, I'd like to
> contribute it to the TechDocs site. There's probably
> much more elegant ways of accomplishing the task on
> the server side; but for non-admin users, it could be
> helpful. Also, it should be easy to translate the
> method to other tools/languages.
>
Just for info, there is a (C language) crosstab function in
contrib/tablefunc.
The one in 7.3 has a serious limitation (the source query must ensure
that for each row in the crosstab, there is a record representing each
column of the crosstab, even if the value is NULL).
However the version in 7.4devel (and a 7.3.x compatible update here
http://www.joeconway.com/) eliminates that limitation.
Joe