Ok, I think I am starting to put two-and-two together.... based on your thread and Ted's thread, I just realized that OLD. and NEW. are keywords in postgres.
Alan Hodgson wrote: > On Tuesday 13 February 2007 11:35, Laura McCord > <[EMAIL PROTECTED]> wrote: > >> Here is a question that I am stumped on: >> >> Does postgres even recognize last_inserted() as mysql does? I notice >> that the function fails on that line. >> >> > > Not, that's just a MySQL function. You could, however, look for the > last value of the sequence generator for the table's primary key, which > should be (but may not always be) equivalent. > > However, you are doing far more work than necessary getting the > inserted/updated data; you can just access it through the OLD. and NEW. > records already provided to the trigger. > > http://www.postgresql.org/docs/8.2/interactive/plpgsql-trigger.html > > > ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
