Re: [Pdx-pm] duplicate records

On Oct 18, 2006, at 6:17 PM, Thomas J Keller wrote:

> passwords=# INSERT INTO foobar (SELECT DISTINCT username,
> password,object,url_address,description,status FROM password);
> ERROR: column "password_id" is of type integer but expression is of
> type character varying

something like this may work:

db=# create table newtable as (SELECT DISTINCT on (username)
username, password, object, url_address,description, status from
password);
db=# delete from password where 1>0;
db=# insert into password (username, password, object,
url_address,description, status) SELECT * from newtable;

-selena