Thread

Antw: Selecting empty columns

Gerhard Dieringer <dieringg@eba-haus.de> — 2000-11-28T12:09:59Z

>>> Hans-Jürgen Schönig <hs@cybertec.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