> select * from work_flats where (METRO_ID = 81 or METRO_ID = 82) and
> DISTRICT_ID < 11;
> crashes backend
> pqReadData() -- backend closed the channel unexpectedly.
> while
> select * from work_flats where METRO_ID = 81 or METRO_ID = 82 and
> DISTRICT_ID < 11;
> works ok.
>
> This happens with latest cvs, 6.3.2 has no problem.
postgres=> select * from t where (METRO_ID = 81 or METRO_ID = 82) and
postgres-> DISTRICT_ID < 11;
metro_id|district_id
--------+-----------
81| 1
82| 2
(2 rows)
More details please...
- Tom