Very Computer

Maybe I missed this somewhere.. but how do you drop a whole row or update a=
 whole row with nulls easily?  I understand how to do updates.. but I'd pre=
fer not to have to do update table set col1 =3D null, col2 =3D null, col3 =
=3D null,........  col100 =3D null where col1 =3D "25" or something..

Travis

---------------------------(end of broadcast)---------------------------

Maybe I missed this somewhere.. but how do you drop a whole row

That one is easy:

delete from TABLE where col1=25;

or update a whole row with nulls easily?

Don't know that one. Would be interesting in knowing if there is a way.

The only way I can think of is to delete the row and then re-insert it,
but that depends on how the table is set up (i.e. does it allow NULL in
all fields?):

delete from TABLE where col1=25;
insert into TABLE(col1) values(25);

Just my 2 cents ...

Jc

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org