"Tim Vadnais" <tvadnais(at)earthlink(dot)net> 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
In response to
pgsql-general by date
|Next:||From: Bruno Wolff III||Date: 2004-10-28 17:20:09|
|Subject: Re: '1 year' = '360 days' ????|
|Previous:||From: Tom Lane||Date: 2004-10-28 17:07:21|
|Subject: Re: Question Regarding Locks |