On Aug 31, 2012, at 21:53, Samuel Gendler wrote:
> I have the following crosstab query, which needs to be parameterized in the 2
> inner queries:
>
> SELECT * FROM crosstab(
> $$
> SELECT t.local_key,
>s.sensor_pk,
>CASE WHEN t.local_day_abbreviation IN (?,?,?,?,?,
I have the following crosstab query, which needs to be parameterized in the
2 inner queries:
SELECT * FROM crosstab(
$$
SELECT t.local_key,
s.sensor_pk,
CASE WHEN t.local_day_abbreviation IN (?,?,?,?,?,?,?) THEN
q.dpoint_value
ELSE NULL
END as dpoint
