Re: Insert Ignore or something similar...

["Thomas F. O'Connell" <tfo@xxxxxxxxxxxx>]

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!