RE: INSERT [IGNORE] INTO TABLE

On Tue, 31 Oct 2000, Edmar Wiggers wrote:

> >     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.
> Well, that's a good idea :-) but I'm not sure about how to createsuch procedure. I would appreciate Your help.
                        Petr Jezek