Received: from gw.acate.com.br ([200.215.17.89]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id e9VGT7l78447 for ; Tue, 31 Oct 2000 11:29:07 -0500 (EST) (envelope-from edmar@brasmap.com) Received: from ana ([192.168.1.13]) by gw.acate.com.br (8.9.3/8.9.3) with SMTP id OAA25766; Tue, 31 Oct 2000 14:28:37 -0200 From: "Edmar Wiggers" To: "Petr Jezek" , Subject: RE: INSERT [IGNORE] INTO TABLE Date: Tue, 31 Oct 2000 14:31:29 -0200 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) In-Reply-To: X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 Importance: Normal X-Archive-Number: 200010/25 X-Sequence-Number: 25 > If I try to insert some row which in the table already exist the > postgre don't insert it and tell some error. Everything ok. > I'll insert only if there is not the same (same key) record, > else don't insert and don't tell me errors about it. > In MySQL is a switch [IGNORE]. Not a good feature for me. What do you do if the record already exists? Update it? Check existence and then insert or update. If you want, I guess you could wrap that inside a stored procedure.