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
- From: "Moran.Michael" <[EMAIL PROTECTED]> To: pgsql-sql@postgresql.org Sent: Thu, 24 Mar 2005 17:30:33 -0800 Subject: [SQL] Calling functions from Delete View (+ contrib/pgcrypto) = madness ?? > Hello there, > > I have a View with a Delete rule and I would like the Del

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

2005-03-24 Thread Jim Buttafuoco
t; To: pgsql-sql@postgresql.org Sent: Thu, 24 Mar 2005 17:30:33 -0800 Subject: [SQL] Calling functions from Delete View (+ contrib/pgcrypto) = madness ?? > Hello there, > > I have a View with a Delete rule and I would like the Delete rule to call a > function (and pass-in a few of the t

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

2005-03-24 Thread Moran.Michael
Hello there, I have a View with a Delete rule and I would like the Delete rule to call a function (and pass-in a few of the the underlying View's/Table's column values). How do you do this? When I do it, I keep getting the following error: ERROR: function expression in FROM may not refer to ot