Re: BUG #13635: Interlocks at selection with array_agg - Mailing list pgsql-bugs

From Francisco Olarte
Subject Re: BUG #13635: Interlocks at selection with array_agg
Date
Msg-id CA+bJJbwpBXRsAXUNkONhZQLd2Mk4CR2QVEkYowA7YtQ-zS=BSA@mail.gmail.com
Whole thread Raw
In response to BUG #13635: Interlocks at selection with array_agg  (pawel.samysev@gmail.com)
Responses Re: BUG #13635: Interlocks at selection with array_agg  (Павел Самусев<pawel.samysev@gmail.com>)
List pgsql-bugs
Hi pawel:

On Thu, Sep 24, 2015 at 11:56 AM,  <pawel.samysev@gmail.com> wrote:

Not seeing the whole query I cannot say too much but:

>     WHERE
>         p.phone_id BETWEEN :min AND :max

=C2=BF Are you sure you're not getting fencepost overlaps when substituting
:min/:max ? ( between does closed intervals, normally half closed (
phone_id >=3D min and phone_id<max ) are used for this kinds of queries
( I ask because it seems a query doing b-c could lock out other doing
a-b for a long time ).

Francisco Olarte.

pgsql-bugs by date:

Previous
From: pawel.samysev@gmail.com
Date:
Subject: BUG #13635: Interlocks at selection with array_agg
Next
From: jeff.janes@gmail.com
Date:
Subject: BUG #13636: psql numericlocale adds comma where it ought not