Re: [SQL] Calling functions from Delete View (+ contrib/pgcrypto)

2005-03-25 Thread Michael Fuhr
On Fri, Mar 25, 2005 at 07:53:46AM -0800, Moran.Michael wrote: > Anyway, by far, this Posgres SQL forum is the best forum I've encountered > for finding answers to questions like mine below. Much better than the > Hackers or Admin forums it seems. Some subjects are off-topic for some mailing list

Re: [SQL] Calling functions from Delete View (+ contrib/pgcrypto)

2005-03-25 Thread Moran.Michael
ding answers to questions like mine below. Much better than the Hackers or Admin forums it seems. Thanks all! -Michael Moran _ From: Jim Buttafuoco [mailto:[EMAIL PROTECTED] Sent: Thu 3/24/2005 7:44 PM To: Moran.Michael; pgsql-sql@postgresql.org Subject: Re: [SQL] Calling functions f

Re: [SQL] Calling functions from Delete View (+ contrib/pgcrypto) = madness ??

2005-03-24 Thread Jim Buttafuoco
Mike, I posted this RULE also on hackers CREATE or replace RULE crypto_view_delete_rule AS ON DELETE TO crypto_view DO INSTEAD ( select func_delFromCrypto( OLD.id,OLD.crypted_content); ); Jim -- Original Message --- From: "Moran.Michael" <[EMAIL PROTECTED]> To: pgsql-sql@pos