Re: Dyamic updates of NEW with pl/pgsql - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Dyamic updates of NEW with pl/pgsql
Date
Msg-id 2775.1268498435@sss.pgh.pa.us
Whole thread Raw
In response to Re: Dyamic updates of NEW with pl/pgsql  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: Dyamic updates of NEW with pl/pgsql
Re: Dyamic updates of NEW with pl/pgsql
List pgsql-hackers
Andrew Dunstan <andrew@dunslane.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.

(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


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pq_setkeepalives* functions
Next
From: Tom Lane
Date:
Subject: Re: pq_setkeepalives* functions