réintegrarion des numeros d'operation dans station

[cedric]

select * from wrbd.fish_fi left join (select * from wrbd.operation_op where op_nbtotal>0)as ope
on (fi_date,fi_st_id)=(ope.op_date,ope.op_st_id)
except (
select distinct on (fi_id) * from(
select * from wrbd.fish_fi left join (select * from wrbd.operation_op where op_nbtotal>0)as ope
on (fi_date,fi_st_id)=(ope.op_date,ope.op_st_id) ) as sub)

--2357

alter table wrbd.fish_fi add column fi_op_id integer;
-- generation du script d'insert à sauvegarder dans fish_update.txt (je passe au inner join pour ne pas avoir de lignes vides)
-- il faut ensuite remplacer "" par ' et " par rien dans notepad.
-- il doit y avoir encore mieux mais je ne vois pas
select *

from wrbd.fish_fi join (select * from wrbd.operation_op where op_nbtotal>0)as ope

on (fi_date,fi_st_id)=(ope.op_date,ope.op_st_id)

select 'update wrbd.fish_fi set fi_op_id= '

cast(op_id as text)

' where fi_st_id="'

cast(fi_st_id as text)

'";'

from wrbd.fish_fi join (select * from wrbd.operation_op where op_nbtotal>0)as ope

on (fi_date,fi_st_id)=(ope.op_date,ope.op_st_id)
order by fi_id ;