Re: NEW used in a query that is not in a rule

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
Subject: Re: NEW used in a query that is not in a rule
Date: 2004-09-14 21:57:03
Message-ID: 4147692F.6000304@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 in a command string given to
>> EXECUTE. You probably need to set up an IF...ELSIF...ELSE...END IF
>> structure to get the value to put into the command string.

I can't because the combination are not a limited number.

Regards
Gaetano Mendola

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Sailesh Krishnamurthy 2004-09-15 03:49:01 Re: beta1 & beta2 & Windows & heavy load
Previous Message Jim C. Nasby 2004-09-14 21:51:14 Re: APR 1.0 released