From: | Joe Conway <mail(at)joeconway(dot)com> |
---|---|
To: | David Johnston <polobo(at)yahoo(dot)com> |
Cc: | 'Andreas' <maps(dot)on(at)gmx(dot)net>, 'Samuel Gendler' <sgendler(at)ideasculptor(dot)com>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: generic crosstab ? |
Date: | 2012-04-24 22:04:21 |
Message-ID: | 4F972365.7070302@joeconway.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On 04/24/2012 02:42 PM, David Johnston wrote:
> You must specify the output record structure:
>
> SELECT crosstab(text, text) AS ( col1_name col1_type [, colN_name
> colN_type]* )
>
> Whether this relates to the “materialization node” message you are
> receiving I have no idea.
The error is because you are selecting from a set returning function in
the target list rather than the from clause. It should be more like:
SELECT * FROM crosstab(text, text) AS ( col1_name col1_type [, colN_name
> colN_type]* )
HTH,
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas | 2012-04-24 22:37:06 | Re: generic crosstab ? |
Previous Message | David Johnston | 2012-04-24 21:42:49 | Re: generic crosstab ? |