need clean way to copy col vals from one rec to another - Mailing list pgsql-general

create table foo (name text, company text,  job text);

insert into foo (name,company,job) values (‘joe’,’ge’,’engineer’);

insert into foo (name) values (‘sue’);

What I want to do is map joe’s company and job over to the sue record, ending up with....

‘sue’ ‘ge’ ‘engineer’

Is there a quick/clever.efficient way to do this?

Thanks in Advance