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. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
