Está probado y anda:
create function fntasas() returns
table (tid integer, ttasa decimal(10,8), lx decimal(10,8), dx
decimal(10,8)) as
$$
declare
lx1 decimal(10,8):= 1.0;
dx1 decimal(10,8):= 0.0;
lr_registro RECORD;
begin
FOR lr_registro IN select id,tasa from tasas ORDER BY id LOOP
tid :=
Hola lista
Algo así seria:
WITH RECURSIVE t(id,tasa,lx,dx) AS (
SELECT a.id,a.tasa,1::numeric as lx,1*a.tasa as dx
FROM (values(65,0.013670563
),(66,0.015125920),(67,0.016741070),(68,0.018533249),(69,0.020521473),(70,0.022726715))
as a(id,tasa)
where id=65
Es mi idea o estas tratando de armar los saldos in solutos, intereses y
pagos con interes compuesto ?
On 31/10/2018 7:58 AM, Jorge Barzola wrote:
Hola estimados:
Necesito armar el siguiente cuadro:
id | tasa | lx | dx