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
Hi there,
I want to know that is a posibillity to test if a statement is prepared in
PL/PgSQL.
I have create a function:
.
PREPARE PSTAT_SAVE_record(INTEGER, INTEGER, DATE, VARCHAR) AS INSERT INTO
table VALUES($1, $2, $3, $4);
.
When I try to execute it second time I got an er
