Re: Insert Ignore or something similar...

I don't think any such behavior exists in PostgreSQL, and based on a
reading of the behavior in MySQL, I can't imagine it ever existing
considering the preference of PostgreSQL developers for correct (and
sane) behavior. INSERT IGNORE seems like a foot-cannon...

--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC

Strategic Open Source: Open Your i™

http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-469-5150
615-469-5151 (fax)

On Sep 5, 2005, at 5:20 PM, Cristian Prieto wrote:

> Hello everybody,
>
> I've just wondered if there are any way to implement an INSERT
> IGNORE in PostgreSQL, I know, I could catch an exception in PL/
> pgSQL and just handle it in the right way, but I would need to
> write a SP for the task. I've been lookin into the documentation
> and I found no similar INSERT IGNORE.
>
> Thanks a lot!