On Monday, December 8, 2014, Huang, Suya <suya.hu...@au.experian.com> wrote:
> -----Original Message----- > From: pgsql-general-ow...@postgresql.org <javascript:;> [mailto: > pgsql-general-ow...@postgresql.org <javascript:;>] On Behalf Of David G > Johnston > Sent: Monday, December 08, 2014 1:18 PM > To: pgsql-general@postgresql.org <javascript:;> > 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.p...@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.
