Re: array_agg + limit

Hello

probably you want

select array_agg(patente) from (select patente from dia4.infaccion
ORDER BY fecha DESC LIMIT 6) x

Regards

Pavel

2010/11/27 Emanuel Calvo Franco <postgres(dot)arg(at)gmail(dot)com>:
> 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
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>