Re: Dyamic updates of NEW with pl/pgsql

2010/3/13 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
>> I think we need some operator on records+strings for this functionality.
>
> I don't see how you're going to do that without utterly compromising the
> type system.
>
> It's not so horrid to do this type of thing in plperl, pltcl etc because
> you've already bought into an "everything is text" worldview when you
> use those languages.  But plpgsql is strongly typed just like SQL is,
> and I don't think we should undo that.
>

strong typing isn't problem for field updating - and we can do
necessary conversion to target type - for simple expression (without
cached plan).

I like some
var = record[expression];
record[expression] = var;

I don't thing so current static naturel of plpgsql is impossible
problem. It needs just more inteligent assign statement.

Pavel

> (This will also be my main objection to letting hstore into core.
> It has not solved the problem of handling real datatypes.)
>
>                        regards, tom lane
>