Skip site navigation (1) Skip section navigation (2)

Antw: Selecting empty columns

From: "Gerhard Dieringer" <DieringG(at)eba-haus(dot)de>
To: <hs(at)cybertec(dot)at>, <pgsql-sql(at)postgresql(dot)org>
Subject: Antw: Selecting empty columns
Date: 2000-11-28 12:09:59
Message-ID: sa23aeb2.056@kopo001 (view raw or flat)
Thread:
Lists: pgsql-sql
>>> Hans-Jürgen Schönig <hs(at)cybertec(dot)at> 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




pgsql-sql by date

Next:From: pgsql-sqlDate: 2000-11-28 12:51:27
Subject: Re(2): 7.0.3 BUG
Previous:From: Colleen WilliamsDate: 2000-11-28 11:59:57
Subject: Re: Persistent Connects (pg_pconnect)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group