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
);//there was no error Hope this helps. Best regards, Andy. - Original Message - From: "Stef" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, May 10, 2004 4:08 PM Subject: [SQL] Exceptions when 0 rows affected. Hi all, I've been looking on Google,the arch

[SQL] Exceptions when 0 rows affected.

2004-05-10 Thread Stef
Hi all, I've been looking on Google,the archives and documentation, but cannot find what I'm looking for. Maybe I've read the answer, but it's still evading me. I'm working with postgres 7.3.4 using the psql client. I want to know if it's possible to raise an error in a transactional BEGIN->EN