Re: [SQL] Selecting empty columns

2000-11-28 Thread Ross J. Reedstrom
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_c

Antw: [SQL] Selecting empty columns

2000-11-28 Thread Gerhard Dieringer
>>> Hans-Jürgen Schönig <[EMAIL PROTECTED]> 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 columnna

[SQL] Selecting empty columns

2000-11-28 Thread Hans-Jürgen Schönig
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