> 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.
- [SQL] INSERT [IGNORE] INTO TABLE Petr Jezek
- RE: [SQL] INSERT [IGNORE] INTO TABLE Edmar Wiggers
- RE: [SQL] INSERT [IGNORE] INTO TABLE Petr Jezek
- RE: [SQL] INSERT [IGNORE] INTO TABLE Edmar Wiggers
- Re: [SQL] INSERT [IGNORE] INTO TABLE Najm Hashmi
- Re: [SQL] INSERT [IGNORE] INTO TABLE Bruce Momjian
- RE: [SQL] INSERT [IGNORE] INTO TABLE K Parker