Skip site navigation (1) Skip section navigation (2)

INSERT [IGNORE] INTO TABLE

From: Petr Jezek <jez20um(at)axpsu(dot)fpf(dot)slu(dot)cz>
To: pgsql-sql(at)postgresql(dot)org
Subject: INSERT [IGNORE] INTO TABLE
Date: 2000-10-31 16:05:17
Message-ID: Pine.LNX.4.10.10010311650340.30822-100000@axpsu.fpf.slu.cz (view raw or flat)
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]. 

				Thanx for help

						Petr Jezek


Responses

pgsql-sql by date

Next:From: Kovacs Zoltan SandorDate: 2000-10-31 16:20:42
Subject: Re: Need info: pl/pgsql performance
Previous:From: Najm HashmiDate: 2000-10-31 15:39:31
Subject: Need help! parse erro

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group