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

PG Bug reporting form <noreply@postgresql.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