On Mon, Nov 13, 2006 at 11:36:05 +0100, Marko Rihtar <[EMAIL PROTECTED]> wrote: > > i'm trying to do update on multiple tables but don't know how. > is something like this posible with postgresql?
I believe you need to use multiple update statements to do this. Each update can only update one table. You can join with other tables to select which rows to update, but that doesn't let you update more than one table at once. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match