Обсуждение: Query on Oracle 10g Merge Function equivalent command/function in Postgre

Query on database migration<br />--------------------------------<br />  <br />We are thinking of migrating one
applicationfrom Oracle 10g to <br />Postgre environment. We are using Oracle 10g Merge functionality to comprae <br
/>and filterout the  records into two groups. The master database <br />size is having about 11 million records and
comparisiontable which <br />is to be compared can have upto 130000 records. This is a <br />continous process and
dailysome 1200 such comparisns are done.<br /><br />Could you guide me if their is any equivalent functionality to <br
/>thatof Oracle Merge function available in any of the postgre version or any best way to do this task to get maximum
throughputandperformance. <br /><br />Your reply would be highly appreciated. <br /><br />with regards, <br /><br
/>I.P.S.Sethi <br />Technical Director, <br />National Informatics Centre, <br />Department of Information Technology,
<br/>New Delhi. <br /><br />