Re: pivot-like transformation

Torsten Lange wrote:
> Hello,
> I have a table with measurement values and columns like this:
> analyses(id, sample_id, parameter[temperatur...], value, unit[?C...], error)
>
> With PL/PgSQL at the end I want try to perform a pivot-like arrangement of
> these data:
> sample_id|Temperature [?C]|parameter2 [mg/L]|...|parameterN [L/year]
> ---------+----------------+-----------------+---+-------------------
> 5 | 23.00| 0.036|...| 35.1

Not a direct answer with respect to plpgsql, but for pivot table
functionality see the contrib/tablefunc function crosstab().

> I also found very few sources about handling of arrays and how to fill them up
> with query results... things like this. Does anyone know a more comprehensive
> source?

Have you looked at the online docs?
http://www.postgresql.org/docs/7.4/static/arrays.html
http://www.postgresql.org/docs/7.4/static/functions-array.html
http://www.postgresql.org/docs/7.4/static/functions-comparisons.html
http://www.postgresql.org/docs/7.4/static/sql-expressions.html#SQL-SYNTAX-ARRAY-CONSTRUCTORS

HTH,

Joe