I need help with a rule to relocate duplicate records
От | Guy Fraser |
---|---|
Тема | I need help with a rule to relocate duplicate records |
Дата | |
Msg-id | 3EC2BF0F.1070709@incentre.net обсуждение исходный текст |
Ответы |
Re: I need help with a rule to relocate duplicate records
|
Список | pgsql-sql |
I made a rule : CREATERULE ins_2003_may ASON INSERT TOdetail_2003may WHEREEXISTS ( SELECT "Acct-Status-Type", "User-Name", "Realm", "Called-Station-Id", "Calling-Station-Id", "Service-Type", "Framed-Protocol", "Client-IP-Address", "NAS-IP-Address", "NAS-Port-Type", "NAS-Port-Id", "Acct-Session-Id"FROM detail_2003may WHERE "Acct-Status-Type" = NEW."Acct-Status-Type" AND "User-Name" = NEW."User-Name"AND "Realm" = NEW."Realm" AND "Called-Station-Id" = NEW."Called-Station-Id" AND "Calling-Station-Id" =NEW."Calling-Station-Id" AND "Service-Type" = NEW."Service-Type" AND "Framed-Protocol" = NEW."Framed-Protocol" AND "Client-IP-Address"= NEW."Client-IP-Address" AND "NAS-IP-Address" = NEW."NAS-IP-Address" AND "NAS-Port-Type" = NEW."NAS-Port-Type"AND "NAS-Port-Id" = NEW."NAS-Port-Id" AND "Acct-Session-Id" = NEW."Acct-Session-Id" ) DOINSTEAD INSERT INTO dups_2003may VALUES ( NEW."Time-Stamp", NEW."Acct-Status-Type", NEW."User-Name", NEW."User-Realm", NEW."Realm", NEW."Acct-Session-Time", NEW."Acct-Input-Octets", NEW."Acct-Output-Octets", NEW."Called-Station-Id", NEW."Calling-Station-Id", NEW."Acct-Terminate-Cause", NEW."Framed-IP-Address", NEW."Service-Type", NEW."Framed-Protocol", NEW."Client-IP-Address", NEW."NAS-IP-Address", NEW."NAS-Port-Type", NEW."NAS-Port-Id", NEW."Timestamp", NEW."Acct-Session-Id", NEW."Acct-Link-Count", NEW."Acct-Multi-Session-Id", NEW."Acct-Delay-Time" ) ; What I wanted was that when data is inserted into detail_2003may then : If a similar record exists then only insert the data into dups_2003may, otherwise only insert the "uniq" data into detail_2003may. What is happening is that all data is being put into dups_2003may, and only records with "uniq" data is being put into detail_2003may. Is there a way to do what I wanted? Guy
В списке pgsql-sql по дате отправления: