Emanuel Calvo Franco wrote:
I'm having this 'issue':
coches=# select array_agg(patente order by fecha desc) from
dia4.infraccion limit 6;
array_agg
--------------------------------------------------------------------------
-----------------------------------------------------------------
--------------------------------------------------------------------------
{565538,726668,639414,739391,674212,941061,636533,981958,999057,743729,548494,923939,841427,454574,363754,670514,566266,251071,852043,1537
11,952549,129124,446671,476345,168905,308274,404812,501024,738098,636071}
(1 row)
I now [know] why it happens an[d] how [to] avoid it, but.... it's ok?
Must work like this?
Yes and yes. LIMIT applies to the number of rows, and that's how it's documented.
<http://www.postgresql.org/docs/9.0/interactive/queries-limit.html>
--
Lew
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
