Re: crosstab query script (python) attached

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