Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAFI7rm24299 for ; Thu, 15 Nov 2001 13:07:53 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id fAFHnwp71413 for pgsql-sql@postgresql.org; Thu, 15 Nov 2001 12:49:58 -0500 (EST) (envelope-from news) From: "Jack Gao" X-Newsgroups: comp.databases.postgresql.sql Subject: Re: Is this a bug? Date: Thu, 15 Nov 2001 09:50:00 -0800 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 29 Message-ID: <9t0v84$25ni$1@news.tht.net> References: X-Complaints-To: scrappy@hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 To: pgsql-sql@postgresql.org X-Archive-Number: 200111/278 X-Sequence-Number: 5660 "Roland Roberts" wrote in message news:m2ofm4gfxs.fsf@tycho.rlent.pnet... > >>>>> "Jack" == Jack Gao 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