| From: | Joe Conway <mail(at)joeconway(dot)com> |
|---|---|
| To: | Andrew Gould <andrewgould(at)yahoo(dot)com> |
| Cc: | Postgres Mailing List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: crosstab query script (python) attached |
| Date: | 2003-06-26 20:41:34 |
| Message-ID: | 3EFB5A7E.9020003@joeconway.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Gould | 2003-06-26 21:19:53 | Re: crosstab query script (python) attached |
| Previous Message | Andrew Gould | 2003-06-26 20:36:18 | crosstab query script (python) attached |