Received: from huey.jpl.nasa.gov (huey.jpl.nasa.gov [128.149.68.100]) by hub.org (8.10.1/8.10.1) with ESMTP id e5O3U4187516; Fri, 23 Jun 2000 23:30:05 -0400 (EDT) Received: from golem.jpl.nasa.gov (hectic-2 [128.149.68.204]) by huey.jpl.nasa.gov (8.8.8+Sun/8.8.8) with ESMTP id UAA23629; Fri, 23 Jun 2000 20:29:58 -0700 (PDT) Received: from alumni.caltech.edu (localhost.localdomain [127.0.0.1]) by golem.jpl.nasa.gov (Postfix) with ESMTP id 0EFC16F4F; Sat, 24 Jun 2000 03:31:20 +0000 (UTC) Message-ID: <39542B87.EEC820FD@alumni.caltech.edu> Date: Sat, 24 Jun 2000 03:31:20 +0000 From: Thomas Lockhart Organization: Yes X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.14-15mdksmp i686) X-Accept-Language: en MIME-Version: 1.0 To: Jeff MacDonald Cc: pgsql-sql@postgresql.org, pgsql-hackers@postgresql.org Subject: Re: query failed , don't know why References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200006/975 > UPDATE members m,payments p SET m.status = 2 > WHERE p.paydate > 'now'::datetime - '1 month'::timespan > and p.productid = 'xxxxxxx' and m.gid = p.gid Try UPDATE members set status = 2 FROM payments p WHERE p.paydate > timestamp 'now' - interval '1 month' AND p.productid = 'xxxxxxx' and members.gid = p.gid;