Antw: Selecting empty columns

>>> 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