How can I do "OLD.columnName != NEW.columnName" if I don't know what the
columnNames are at Compile Time?
I have the columnName in a variable.
Are you trying to do this from a plpgsql function? If so then I think
you should try to do this from a C function.
With C functions you will get more
On Jun 16, 2007, at 6:26 AM, Noah Heusser wrote:
I want to implement a trigger-function witch can fill the following
table.
Each data manipulation (INSERT, UPDATE or DELETE) gets logged.
The function should work as trigger on diffrent tables.
CREATE TABLE logtable (
operationCHAR(6) C
Sergey Konoplev schrieb:
My Question:
How can I do "OLD.columnName != NEW.columnName" if I don't know what the
columnNames are at Compile Time?
I have the columnName in a variable.
I suggest you use plpython. In this case you'll be able to do it.
TD['old'][colNameVar] != TD['new'][colNameVar]
My Question:
How can I do "OLD.columnName != NEW.columnName" if I don't know what the
columnNames are at Compile Time?
I have the columnName in a variable.
I suggest you use plpython. In this case you'll be able to do it.
TD['old'][colNameVar] != TD['new'][colNameVar]
--
Regards,
Sergey Konop
How can I do "OLD.columnName != NEW.columnName" if I don't know what the
columnNames are at Compile Time?
I have the columnName in a variable.
Are you trying to do this from a plpgsql function? If so then I think
you should try to do this from a C function.
With C functions you will get more
On 6/16/07, Noah Heusser <[EMAIL PROTECTED]> wrote:
Hi
I want to implement a trigger-function witch can fill the following table.
Each data manipulation (INSERT, UPDATE or DELETE) gets logged.
The function should work as trigger on diffrent tables.
CREATE TABLE logtable (
operationCHA
Hi
I want to implement a trigger-function witch can fill the following table.
Each data manipulation (INSERT, UPDATE or DELETE) gets logged.
The function should work as trigger on diffrent tables.
CREATE TABLE logtable (
operationCHAR(6) CHECK (change_type IN ('DELETE', 'INSERT', 'UPDAT
