Peter Kroon wrote: > Is anyone able to reproduce? > When I run the query below all 5 rows are returned instead of 2. > Or is this the default behaviour..
> SELECT > xmlagg( [...]
> )--xmlagg > FROM __pg_test_table AS dh > WHERE dh.__rel=5 LIMIT 2 --OFFSET 10;
According to the documentation, that query should return exactly one row since xmlagg is an aggregate.
So the LIMIT 2 won't do anything to the result.
You can wrap your query in a SELECT count(*) FROM (SELECT ...) AS dummy; to see how many rows you got.