Re: Is this a bug? - Mailing list pgsql-sql

From Jack Gao
Subject Re: Is this a bug?
Date
Msg-id 9t0v84$25ni$1@news.tht.net
Whole thread Raw
In response to Re: Is this a bug?  (Roland Roberts <roland@astrofoto.org>)
List pgsql-sql
"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




pgsql-sql by date:

Previous
From: Roelof Sondaar
Date:
Subject: How to use COPY in a function ?
Next
From: frbn@efbs-seafrigo.fr
Date:
Subject: SELECT * FROM t where p or q;