Re: Inspection of row types in pl/pgsql and pl/sql - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Inspection of row types in pl/pgsql and pl/sql
Date
Msg-id 17110.1258226857@sss.pgh.pa.us
Whole thread Raw
In response to Re: Inspection of row types in pl/pgsql and pl/sql  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: Inspection of row types in pl/pgsql and pl/sql
List pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> Tom Lane wrote:
>> Perhaps it would help if we looked at some specific use-cases that
>> people need, rather than debating abstractly.  What do you need your
>> generic trigger to *do*?

> The two things I have wanted most badly in the past are

> a) to be able to address a field in NEW and OLD by a string name 
> (usually passed in via a trigger argument) and

But what are you then going to do with that field?  Are you just
assuming that it will be of a pre-agreed datatype?  Or that you
can perform some specific operation on it?  What are you expecting
will happen if it isn't or can't?

> b) to be able to discover the names if the fields in NEW and OLD

It doesn't seem hard or ugly to provide an API for that, but again
I'm wondering what happens next.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Inspection of row types in pl/pgsql and pl/sql
Next
From: Robert Haas
Date:
Subject: patch - per-tablespace random_page_cost/seq_page_cost