That's one of the examples I was talking about. The function that is created in the example returns type "trigger" (quotes added for emphasis). When I try that in my version, it says 'parse error at or near "trigger"'. Another example said to use void, another said opaque. All caused the parser to complain.
<br><br><div><span class="gmail_quote">On 8/13/07, <b class="gmail_sendername">Kevin C. Smith</b> <<a href="mailto:kevin@linuxsmith.com">kevin@linuxsmith.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On Mon, 2007-08-13 at 22:02 -0500, Tim Wilson wrote:<br>> I'm using Postgres 7.1.3, and I'm trying to set up a trigger. I have<br>> a last_updated column on all of my tables, that is of type timestamp.<br>> I want to set the field every time the record is updated. I thought a
<br>> trigger would be best for that, but every example I find via Google<br>> doesn't work. One said to create a function that returned type<br>> TRIGGER, another said type VOID, neither of which worked. Every
<br>> example I find uses one of those return types. Anyone have any<br>> ideas?<br><br>I haven't tried triggers with postgresql, but I think it's a two<br>step thing in most cases. Write a function, then create a trigger
<br>to call that function on insert or update.<br><br>Try:<br><a href="http://www.postgresql.org/docs/8.2/static/triggers.html">http://www.postgresql.org/docs/8.2/static/triggers.html</a><br><a href="http://www.postgresql.org/docs/8.2/static/plpgsql.html">
http://www.postgresql.org/docs/8.2/static/plpgsql.html</a><br><br>Religion is regarded by the common people as true, by the wise as false,<br>and by the rulers as useful. --- Lucius Annaeus Seneca<br><br>_______________________________________________
<br>Cialug mailing list<br><a href="mailto:Cialug@cialug.org">Cialug@cialug.org</a><br><a href="http://cialug.org/mailman/listinfo/cialug">http://cialug.org/mailman/listinfo/cialug</a><br></blockquote></div><br><br clear="all">
<br>-- <br>Tim