Re: Exceptions when 0 rows affected. - Mailing list pgsql-sql

From Stef
Subject Re: Exceptions when 0 rows affected.
Date
Msg-id 20040513164936.6fad8cc5@svb.ucs.co.za
Whole thread Raw
In response to Exceptions when 0 rows affected.  (Stef <svb@ucs.co.za>)
List pgsql-sql
Andrei Bintintan mentioned :
=> Your problem depends on what interface/programming language you're using.

Yep, I tried to do it using rules or triggers, but I can't get it to do what I want 
exactly, and it's not a good idea to put any rules or triggers on my database.

I'm sticking to psql though, and managed to create the query with a nested
nullif and coalesce to make my query fail if there are 0 rows matching for
an update or delete.

Cheers
Stef


pgsql-sql by date:

Previous
From: Yasir Malik
Date:
Subject: Re: a wierd query
Next
From: Edmund Bacon
Date:
Subject: Re: a wierd query