RE: INSERT [IGNORE] INTO TABLE - Mailing list pgsql-sql

From Edmar Wiggers
Subject RE: INSERT [IGNORE] INTO TABLE
Date
Msg-id NEBBIAKDCDHFGJMLHCKIOEMNCAAA.edmar@brasmap.com
Whole thread Raw
In response to INSERT [IGNORE] INTO TABLE  (Petr Jezek <jez20um@axpsu.fpf.slu.cz>)
Responses RE: INSERT [IGNORE] INTO TABLE
List pgsql-sql
>     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.



pgsql-sql by date:

Previous
From: Kovacs Zoltan Sandor
Date:
Subject: Re: Need info: pl/pgsql performance
Next
From: Petr Jezek
Date:
Subject: RE: INSERT [IGNORE] INTO TABLE