Re: FW: SQL rolling window without aggregation
| От | David Johnston |
|---|---|
| Тема | Re: FW: SQL rolling window without aggregation |
| Дата | |
| Msg-id | CAKFQuwaaKOmfpdbMV+OGSMxx7-5sKpSM+_w5L6pve9mGEWSR-Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: FW: SQL rolling window without aggregation ("Huang, Suya" <Suya.Huang@au.experian.com>) |
| Список | pgsql-general |
On Monday, December 8, 2014, Huang, Suya <Suya.Huang@au.experian.com> wrote:
-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of David G Johnston
Sent: Monday, December 08, 2014 1:18 PM
To: pgsql-general@postgresql.org
Subject: Re: FW: [GENERAL] SQL rolling window without aggregation
Huang, Suya wrote
> It seems like it's not been sent to the SQL group, so I'm trying with
> this group.
Asked and answered...online archives follow
http://postgresql.nabble.com/rolling-window-without-aggregation-td5829344.html#a5829345
http://www.postgresql.org/message-id/1417764928965-5829345.post@n5.nabble.com
David J.
============================================================================================================
Thanks Dave. I was trying to avoid UNION...
Instead of avoiding things get something that works then ask whether there is a better way to do things. At least that way you can provide a working query that others can look at and know exactly what you need.
In this case you have a single table and want the result to have more rows than the input - I'm not sure how anything but a union will accomplish that goal. You have to generate those rows somehow. There may be better ways of looking at your problem but you only gave us a toy model to play with.
David J.
В списке pgsql-general по дате отправления: