W dniu 04/26/2013 12:25 AM, Merlin Moncure pisze:
On Thu, Apr 25, 2013 at 1:30 PM, Rafał Pietrak <rafal@xxxxxxxxxxxxxxxxxx> wrote:
[----------------------]
No, I don't (manual:
http://www.postgresql.org/docs/9.1/static/tutorial-window.html, have just
one word "distinct" on that page, and it's not in the above context). And I
cannot duplicate the above:
--------------------------------------------
# select array_agg(distinct v order by v desc) from (select
generate_series(1,3) v union all select generate_series(1,3)) q;
ERROR: syntax error at or near "order"
LINE 1: select array_agg(distinct v order by v desc) from (select ge...
--------------------------------------------
Did I miss something??
This feature was added w/9.0. This means you are on 8.4. Time to upgrade...
Yes, true. I kind of postpone that until debian-wheeze gets released as
stable.
But what about the postgres documentation. I haven't found that feature
in postgres-v9.1 docs (link above). Where can I read about it?
-R
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
