Re: dynamic plpgsql question - Mailing list pgsql-general

From Tom Lane
Subject Re: dynamic plpgsql question
Date
Msg-id 8844.1166028846@sss.pgh.pa.us
Whole thread Raw
In response to dynamic plpgsql question  (Marc Evans <Marc@SoftwareHackery.Com>)
List pgsql-general
Marc Evans <Marc@SoftwareHackery.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

pgsql-general by date:

Previous
From: David Goodenough
Date:
Subject: MySQL drops support for most distributions
Next
From: Marc Evans
Date:
Subject: Re: dynamic plpgsql question