On Mon, 5 Apr 2004 13:01:39 -0400 (EDT)
"Gavin" <[EMAIL PROTECTED]> wrote:
> Hi All, I have been tinkering with a function to log the changes made on
> any column through a function and trigger. However, I cant think of a way
> to make this work through pl/pgsql. Any one have any ideas, or is it
A plpython solution is available in Issue #66 of PostgreSQL GeneralBits.
http://www.varlena.com/GeneralBits/66
Let me know if this helps.
elein
On Mon, Apr 05, 2004 at 01:01:39PM -0400, Gavin wrote:
> Hi All, I have been tinkering with a function to log the changes made on
> any column through a
"Gavin" <[EMAIL PROTECTED]> writes:
> Hi All, I have been tinkering with a function to log the changes made on
> any column through a function and trigger. However, I cant think of a way
> to make this work through pl/pgsql.
plpgsql won't do it, but you could do it in pltcl, I believe.
Or resort
Gavin,
> Hi All, I have been tinkering with a function to log the changes made on
> any column through a function and trigger. However, I cant think of a way
> to make this work through pl/pgsql. Any one have any ideas, or is it just
> not possible?
It could be done, but would be extremely slow
Hi All, I have been tinkering with a function to log the changes made on
any column through a function and trigger. However, I cant think of a way
to make this work through pl/pgsql. Any one have any ideas, or is it just
not possible?
SNIP
create or replace function logchange2() returns OPAQUE a