agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: ml@ft-c.de
To: pgsql-sql@lists.postgresql.org
Subject: recursive sql
Date: Sun, 9 Aug 2020 08:28:44 +0200
Message-ID: <eaf4082e-79ac-7a5d-bcf8-63ce66087365@ft-c.de> (raw)
Hello,
the table
create table tt (
ts timestamp,
c numeric) ;
insert into tt values
('2019-12-31',1), ('2020-01-01',2),
('2020-07-02',3), ('2020-07-06',4),
('2020-07-07',5), ('2020-07-08',6);
My question: It is possible to get an
additional column (named c2)
with
( c from current row ) + ( c2 from the previous row ) as c2
the result:
ts c c2
.. 1 1 -- or null in the first row
.. 2 3
.. 3 6
.. 4 10
...
with recursive ema as ()
select ts, c,
-- many many computed_rows
-- <code> as c2
from tt -- <- I need tt on this place
thank you for help
Franz
view thread (16+ messages) latest in thread
Message-ID: <eaf4082e-79ac-7a5d-bcf8-63ce66087365@ft-c.de>
Permalink: ../eaf4082e-79ac-7a5d-bcf8-63ce66087365@ft-c.de/
Also on: postgresql.org/message-id/eaf4082e-79ac-7a5d-bcf8-63ce66087365@ft-c.de
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ml@ft-c.de, pgsql-sql@lists.postgresql.org
Subject: Re: recursive sql
In-Reply-To: <eaf4082e-79ac-7a5d-bcf8-63ce66087365@ft-c.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox