Re: [HACKERS] NEW used in a query that is not in a rule

2004-09-14 Thread Gaetano Mendola
Oliver Elphick wrote: My guess is that you are having this problem because you are executing a query referring to NEW rather than using it directly. This for sure, I'm able to use NEW directly but I don't know at definition time wich field of NEW I have to use. I don't think you can refer to NEW

Re: [HACKERS] NEW used in a query that is not in a rule

2004-09-14 Thread Oliver Elphick
On Tue, 2004-09-14 at 19:34, Gaetano Mendola wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hi all, > I'm bouncing on the following problem, I don't know if is a bug or if exist a > different > way to do it. > The following code is not meaningfull but it's an extract of what I'm try

Re: [HACKERS] NEW used in a query that is not in a rule

2004-09-14 Thread Passynkov, Vadim
used in a query that is not in a rule -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'm bouncing on the following problem, I don't know if is a bug or if exist a different way to do it. The following code is not meaningfull but it's an extract of what I'm trying

[HACKERS] NEW used in a query that is not in a rule

2004-09-14 Thread Gaetano Mendola
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'm bouncing on the following problem, I don't know if is a bug or if exist a different way to do it. The following code is not meaningfull but it's an extract of what I'm trying to do: CREATE TABLE foo ( field1 INTEGER ); CREATE OR REPLACE FUNC