X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DC1D0D85A4 for ; Tue, 22 Nov 2005 06:40:17 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 84656-01 for ; Tue, 22 Nov 2005 10:40:19 +0000 (GMT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.196]) by svr1.postgresql.org (Postfix) with ESMTP id 1BAB7D7DB4 for ; Tue, 22 Nov 2005 06:40:14 -0400 (AST) Received: by xproxy.gmail.com with SMTP id h30so877905wxd for ; Tue, 22 Nov 2005 02:40:17 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=RJcQlO3eC8Y7qDSQBRYFzxRFJrf50SDXc2biotGyR05w7Umk8V6+iI9/vSgB5zFQkQkXRVduel78nfwRU+0vNURXaX0EQDT19pFSa4oaHx2vxAR509PwpfF5BS6MtyQFGwAiipkdeLlh2zlJ2h05oIM3HDUxPd7jNnaPq+KW1GA= Received: by 10.65.177.9 with SMTP id e9mr574841qbp; Tue, 22 Nov 2005 02:40:17 -0800 (PST) Received: by 10.65.83.10 with HTTP; Tue, 22 Nov 2005 02:40:17 -0800 (PST) Message-ID: <4f34febc0511220240p77b1bc7ctd7635464bfca8311@mail.gmail.com> Date: Tue, 22 Nov 2005 19:40:17 +0900 From: John Barham To: Diego Subject: Re: PG Version 8.1 Cc: pgsql-admin@postgresql.org In-Reply-To: <4383024F.6000406@unimedijui.com.br> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <4383024F.6000406@unimedijui.com.br> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/298 X-Sequence-Number: 19671 On 11/22/05, Diego wrote: > Hi, i use pg version 8.0 and i have this case: > > UPDATE tbpeople > SET dt_update =3D '11/22/2005' > WHERE tbdoctor.id_people =3D tbpeople.id > > But now, in version 8.1, this instrution give me an error: > [ERROR: missing FROM-clause entry for table "tbdoctor"] > > Who can i do now to get the same result? Try: UPDATE tbpeople SET dt_update =3D '11/22/2005' FROM tbdoctor WHERE tbdoctor.id_people =3D tbpeople.id or: UPDATE tbpeople SET dt_update =3D '11/22/2005' WHERE id IN (SELECT id_people FROM tbdoctor) Note that the FROM clause in UPDATE is a PG extension. John > Thanks... > Diego Ziquinatti