Hello
it is possible in 9.1. In older version you have to use a temp table.
Regards
Pavel Stehule
2011/4/14 Steven Dahlin :
> Is it possible to execute an update using recursion? I need to update a set
> of records and also update their children with the same value. I tried the
> following qu
Is it possible to execute an update using recursion? I need to update a set
of records and also update their children with the same value. I tried the
following query but it gave an error at the "update schema.table tbl":
with recursive childTbl( pid,
ppid,
