Received: from mailproxy.de.uu.net (mailproxy.de.uu.net [192.76.144.34]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eASCCet36153 for ; Tue, 28 Nov 2000 07:12:40 -0500 (EST) (envelope-from DieringG@eba-haus.de) Received: from kopo001 (pec-21.au1.f.uunet.de [149.228.241.21]) by mailproxy.de.uu.net (5.5.5/5.5.5) with SMTP id NAA21758 for ; Tue, 28 Nov 2000 13:12:45 +0100 (MET) Received: from EBA_DO-Message_Server by kopo001 with Novell_GroupWise; Tue, 28 Nov 2000 13:10:10 +0100 Message-Id: X-Mailer: Novell GroupWise 5.5.2 Date: Tue, 28 Nov 2000 13:09:59 +0100 From: "Gerhard Dieringer" To: , Subject: Antw: Selecting empty columns Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by mail.postgresql.org id eASCCft36154 X-Archive-Number: 200011/266 X-Sequence-Number: 297 >>> Hans-Jürgen Schönig 28.11.2000 12.39 Uhr >>> > 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 > > Hans try: update tablename set columnname=0 where columnname is null; Gerhard