Re: Easy form of "insert if it isn't already there"?

Maybe to show how "found" works and how to ignore errors - that is my
assumption only.

Regards,
Bartek

2012/2/15 Berend Tober <btober(at)broadstripe(dot)net>

> Chris Angelico wrote:
>
>> On Wed, Feb 15, 2012 at 5:26 PM, Bartosz Dmytrak<bdmytrak(at)eranet(dot)pl>
>> wrote:
>>
>>>
>>> e.g. You can use BEGIN... EXCEPTION.... END, good example of
>>> such approach is
>>> there: http://www.postgresql.org/**docs/9.1/static/plpgsql-**
>>> control-structures.html#**PLPGSQL-UPSERT-EXAMPLE<http://www.postgresql.org/docs/9.1/static/plpgsql-control-structures.html#PLPGSQL-UPSERT-EXAMPLE>
>>> ;
>>>
>>
>>
> I wonder why, in that example, you would not try the INSERT first, and if
> that fails, then do the update?
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general>
>