Re: BUG #19751: MIN aggregate + FETCH FIRST 1 ROW WITH TIES causes false 21000 error when index scan is forced

PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> SELECT MIN(reading) AS minimum
> FROM (
> SELECT reading
> FROM readings
> WHERE region_id = 2
> ) AS scoped
> ORDER BY minimum
> FETCH FIRST 1 ROW WITH TIES;
> Observed result:
> ERROR: more than one row returned by a subquery used as an expression

Thanks for the report, but this was reported and fixed a couple
weeks ago:

https://www.postgresql.org/message-id/flat/19694-4e61bd0475398eef%40postgresql.org

regards, tom lane