Re: Exceptions when 0 rows affected.

From: Stef <svb(at)ucs(dot)co(dot)za>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Exceptions when 0 rows affected.
Date: 2004-05-13 14:49:36
Message-ID: 20040513164936.6fad8cc5@svb.ucs.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-sql by date

  From Date Subject
Next Message Edmund Bacon 2004-05-13 15:27:59 Re: a wierd query
Previous Message Yasir Malik 2004-05-13 13:24:10 Re: a wierd query