Consulta sobre Query Dinamico

[elninon]

Bueno, pude resolverlo utilizando crosstab, de la siguiente manera:

Código MySQL:

SELECT * FROM crosstab
(
'select id, order, value from test ORDER BY 1',
'select distinct order from test ORDER BY 1'
)
AS
(
    id numeric(20),
    value1 text,
    value2 text,
    value3 text
);
 

De aca saque la info para poder aplicarlo:
[URL="http://www.postgresql.org/docs/current/interactive/tablefunc.html"]http://www.postgresql.org/docs/current/interactive/tablefunc.html[/URL]

Saludos!