Re: [SQL] Exceptions when 0 rows affected.

2004-05-13 Thread Stef
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 thoug

Re: [SQL] Exceptions when 0 rows affected.

2004-05-10 Thread Andrei Bintintan
Hi Stef, Your problem depends on what interface/programming language you're using. In a Begin End transaction you will have to verify if the returned data is good for you so then you decide if you run at the end "COMMIT" or "ROLLBACK". In php (and where is compatible) I suggest this: //this is p