RE: INSERT [IGNORE] INTO TABLE

From: "Edmar Wiggers" <edmar(at)brasmap(dot)com>
To: "Petr Jezek" <jez20um(at)axpsu(dot)fpf(dot)slu(dot)cz>, <pgsql-sql(at)postgresql(dot)org>
Subject: RE: INSERT [IGNORE] INTO TABLE
Date: 2000-10-31 16:31:29
Message-ID: NEBBIAKDCDHFGJMLHCKIOEMNCAAA.edmar@brasmap.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Petr Jezek 2000-10-31 17:04:24 RE: INSERT [IGNORE] INTO TABLE
Previous Message Kovacs Zoltan Sandor 2000-10-31 16:20:42 Re: Need info: pl/pgsql performance