"Tim Vadnais" <[EMAIL PROTECTED]> writes: > My questions are: Is there a way I can dynamically determine the number of > fields in the rows that is being maintained.
I'm starting to think there should be a FAQ entry for this ;-) plpgsql is essentially incapable of doing anything that involves dynamic field access, especially if the field types aren't known in advance either. I believe you can do what you want in pltcl, and you can definitely write such a trigger in C, but plpgsql is the wrong tool for the job. If you want to try it in C, there are some relevant examples in contrib/spi/ in the PG source distribution. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html