Re: dynamic plpgsql question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marc Evans <Marc(at)SoftwareHackery(dot)Com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: dynamic plpgsql question
Date: 2006-12-13 16:54:06
Message-ID: 8844.1166028846@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Marc Evans <Marc(at)SoftwareHackery(dot)Com> writes:
> In the trigger, TG_ARGV[0] is the name of a column that I want to
> evaluate.

This is effectively impossible in plpgsql, because it's a statically
typed language --- it wants to know the type of every expression in
advance, and so such a thing couldn't work. Consider using one of the
other PLs instead.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Madison Kelly 2006-12-13 16:57:04 Re: MySQL drops support for most distributions
Previous Message David Goodenough 2006-12-13 16:50:34 MySQL drops support for most distributions