Re: [GENERAL] How to distribute budget value to actual rows in Postgresql

2014-02-09 Thread David Johnston
Andrus Moor wrote > Budget table contains jobs with loads: > > create temp table budget ( > job char(20) primary key, > load numeric(4,1) not null check (load>0 ) > ); > insert into budget values ( 'programmer', 3 ); > insert into budget values ( 'analyst', 1.5 ); >

[GENERAL] How to distribute budget value to actual rows in Postgresql

2014-02-09 Thread Andrus
Budget table contains jobs with loads: create temp table budget ( job char(20) primary key, load numeric(4,1) not null check (load>0 ) ); insert into budget values ( 'programmer', 3 ); insert into budget values ( 'analyst', 1.5 ); Actual table contains actual loads by emp