From: | Emanuel Calvo Franco <postgres(dot)arg(at)gmail(dot)com> |
---|---|
To: | postgresql Forums <pgsql-general(at)postgresql(dot)org> |
Subject: | array_agg + limit |
Date: | 2010-11-27 12:59:37 |
Message-ID: | AANLkTik1mcZCjWmZd+LKTT5Nk2_ELXBsjPgXJFUKCqb8@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 why it happens an how avoid it, but.... it's ok? Must work like this?
--
Emanuel Calvo Franco
DBA | www.emanuelcalvofranco.com.ar
Curso a distancia Nivel 1 Admin Postgres:
http://www.postgresql-es.org/node/525
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2010-11-27 13:29:52 | Re: array_agg + limit |
Previous Message | Dmitriy Igrishin | 2010-11-27 11:10:02 | Re: Terms advice. |