Re: dynmic column names inside trigger?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Louis-David Mitterrand <vindex+lists-pgsql-sql(at)apartia(dot)org>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: dynmic column names inside trigger?
Date: 2007-11-20 16:56:02
Message-ID: 6086.1195577762@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Louis-David Mitterrand <vindex+lists-pgsql-sql(at)apartia(dot)org> writes:
> I'd like to use it on other tables an columns but how can the column
> name be dynamic inside the procedure.

It can't --- plpgsql has no support for that. You could probably make
it work in some of the other PL languages, such as plperl or pltcl,
which are less strongly typed.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Phillip Smith 2007-11-21 03:14:05 Re: string function
Previous Message Louis-David Mitterrand 2007-11-20 16:12:58 dynmic column names inside trigger?