Received: from wallace.ece.rice.edu (wallace.ece.rice.edu [128.42.12.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eASG5dt53041 for ; Tue, 28 Nov 2000 11:05:40 -0500 (EST) (envelope-from reedstrm@rice.edu) Received: by rice.edu via sendmail from stdin id (Debian Smail3.2.0.102) for pgsql-sql@postgresql.org; Tue, 28 Nov 2000 10:05:45 -0600 (CST) Date: Tue, 28 Nov 2000 10:05:45 -0600 From: "Ross J. Reedstrom" To: pgsql-sql@postgresql.org Subject: Re: Selecting empty columns Message-ID: <20001128100545.B14303@rice.edu> Mail-Followup-To: pgsql-sql@postgresql.org References: <3A239986.E7D70B61@cybertec.at> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Mutt/1.0i In-Reply-To: <3A239986.E7D70B61@cybertec.at>; from hs@cybertec.at on Tue, Nov 28, 2000 at 12:39:50PM +0100 X-Archive-Number: 200011/269 X-Sequence-Number: 300 On Tue, Nov 28, 2000 at 12:39:50PM +0100, Hans-Jürgen Schönig wrote: > How can I retrieve empty columns from a table? > The affected column is int4, some row do have values, others are empty - > how can those empty ones be retrieved and updated to 0 UPDATE foo_table SET bar_column = 0 WHERE bar_column IS NULL; Ross -- Open source code is like a natural resource, it's the result of providing food and sunshine to programmers, and then staying out of their way. [...] [It] is not going away because it has utility for both the developers and users independent of economic motivations. Jim Flynn, Sunnyvale, Calif.