On 07/11/2012 05:12 AM, Filipe Brandão wrote:
> Hi all.
> I was wondering if somenone can help me.
> I needed to do a cursor.execute of a function writen in sql.
> The function is:
> IF (TG_OP = 'UPDATE') THEN
> select NEW.test;
> RETURN NEW;
> END IF;
> I always get an error message saying ProgrammingError: syntax error at
> or near "IF"
> is there a way to execute this function inside a python script?
Have had coffee, am now ready for correct answer:( The above code
snippet will only work in a trigger function. My previous suggestion to
use DO was wrong. The only way the above is going to work is in a pgsql
function that is then attached to a trigger.
In response to
psycopg by date
|Next:||From: P. Christeas||Date: 2012-07-20 16:45:02|
|Subject: binary protocol, again|
|Previous:||From: Adrian Klaver||Date: 2012-07-11 13:29:06|
|Subject: Re: SQL If THEN|