From: | Hitesh Patel <hitesh(at)presys(dot)com> |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | Getting INSERT values on a trigger |
Date: | 2000-07-11 21:59:22 |
Message-ID: | 396B98BA.4263CAAB@presys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
I am trying to use a C function to get the values inputted for a given
row. I have defined the trigger as:
CREATE TRIGGER test AFTER INSERT OR UPDATE OR DELETE on testrel FOR
EACH ROW EXECUTE PROCEDURE testfunc();
Now say if I do a 'INSERT INTO testrel VALUES('1','string');' how can I
grab the values for each field within testfunc() and act on them (in
this case spit them out to another file)?
I have read the docs and can't seem to find how to retrieve the
values...
--
+---------------------------------+----------------------------+
| Hitesh Patel | Voice: (541) 759-3126 |
| | Fax: (541) 759-3214 |
| Preferred Communications Inc. | Email: hitesh(at)pciwest(dot)net |
+---------------------------------+----------------------------+
perl -e 'print pack("B*", "0100100100100000011101000110100001" .
"101001011011100110101100100000010010010010000001100100011100" .
"100110000101101110011010110010000001110011011011110110110101" .
"100101001000000110001001100001011001000010000001001110011110" .
"010111000101110101011010010110110000001010");'
From | Date | Subject | |
---|---|---|---|
Next Message | XWorkers | 2000-07-12 01:18:39 | ODBC -- how much stable through internet |
Previous Message | Tom Lane | 2000-07-11 15:48:27 | Re: odbc, postgresql and cobalt Qube/RaQ3 |