Re: [SQL] update on nested table of substitutable value

On 2006-01-30, Antonio 6sette <bottesini_at_libero.it> wrote:
> UPDATE TABLE (
> SELECT dip_var FROM dipendenti
> WHERE id = 1 ) x
> SET x.descr = 'addiz_com'
> WHERE x.descr = 'addiz_reg';
>
>
> but if I try to update an attribute of dip_var_vc2:

update table(select dip_var
  from dipendenti d where id=1) x
  set x=dip_var_vc2(x.id,x.descr,
  x.data_var,x.utente,'Nuovo Valore')
  where treat(value(x) as dip_var_vc2).valore =   'Vecchio valore';

;-)))

-- 
#include <stdio.h>
int main(void){char c[]={10,65,110,116,111,110,105,111,32,98,97,114,98,111,110,
101,32,60,104,105,110,100,101,109,105,116,64,116,105,115,99,97,108,105,110,101,
116,46,105,116,62,10,10,0};printf("%s",c);return 0;}