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
Wayne Cuddy writes:
> The documentation about concurrency states that all the different types
> of locks are table locks even if the word row appears in the lock name.
Section 13.3.1, "Table-level Locks", states that all the lock types
discussed therein are table-level locks, even though some of
The documentation about concurrency states that all the different types
of locks are table locks even if the word row appears in the lock name.
The documentation about select statements states that when "for update
of" is used that only the selected rows will be locked. Is this true or
does this r
