Re: [SQL] pl/PgSQL, variable names in NEW

2008-04-10 Thread Martin Edlman
se.html Oh, I see. I have read the doc "...can be done via the function spi_exec_query described below, or via an experimental module DBD::PgSPI...", but missed the "OR" and thought that DBD::PgSPI is mandatory. Thanks. Martin - -- Regards, Martin Edlman Fortech, spol. s

Re: [SQL] pl/PgSQL, variable names in NEW

2008-04-08 Thread Martin Edlman
END IF; -- code RETURN NEW; END; $BODY$ LANGUAGE 'plpgsql' VOLATILE; | On 07/04/2008, Martin Edlman <[EMAIL PROTECTED]> wrote: |> Hello, |> |> is it possible to use variables as field names in the NEW record? |> Let's suppo

[SQL] pl/PgSQL, variable names in NEW

2008-04-07 Thread Martin Edlman
ISE NOTICE ' value changed from "%" to "%"', OLD.attname, NEW.attname; -- INVOKE OTHER FUNCTION END IF; END LOOP; END; $BODY$ LANGUAGE 'plpgsql' VOLATILE; -- Martin Edlman Fortech Ltd. 57001 Litomys