Thank you. I was trying to do the order by at the sub-query level.
Thanks again.
Woody
iGLASS Networks
www.iglass.net
On Tue, May 14, 2013 at 11:37 AM, Igor Neyman wrote:
>
>
>
> On Tue, May 14, 2013 at 10:08 AM, George Woodring <
> george.woodr...@iglass.net> wrote:
>
>> To summarize my que
On Tue, May 14, 2013 at 10:08 AM, George Woodring <
george.woodr...@iglass.net> wrote:
> To summarize my question at the top, why is it that when I did the JOIN,
> the array_agg results reversed order?
>
> I had a function that ran the following query:
>
> SELECT timeslot, pollgrpid, array_agg(out
To summarize my question at the top, why is it that when I did the JOIN,
the array_agg results reversed order?
I had a function that ran the following query:
SELECT timeslot, pollgrpid, array_agg(outval)
FROM
(SELECT * FROM rrd.a_current WHERE pollgrpid=8 ORDER BY timeslot,
dsnum) AS foo
