Re: Is this a bug?

"Roland Roberts" <roland@astrofoto.org> wrote in message
news:m2ofm4gfxs.fsf@tycho.rlent.pnet...
> >>>>> "Jack" == Jack Gao <wei@gaofamily.org> writes:
>
>     Jack> So, I can't use JOIN in UPDATE?
>
> You are trying to update two different tables.  Use a transaction
> instead.
>
>     begin transaction;
>     update foo ....;
>     update bar ....;
>     end transaction;
>
> roland

No, I just need to update one table, which is tblUserConfig.

> --
>        PGP Key ID: 66 BC 3B CD
> Roland B. Roberts, PhD                             RL Enterprises
> roland@rlenter.com                     76-15 113th Street, Apt 3B
> roland@astrofoto.org                       Forest Hills, NY 11375
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org