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

From Pavel Stehule
Subject Re: Inspection of row types in pl/pgsql and pl/sql
Date
Msg-id 162867790911140921j50227d19r475bf00d6fb67d4@mail.gmail.com
Whole thread Raw
In response to Re: Inspection of row types in pl/pgsql and pl/sql  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
2009/11/14 Andrew Dunstan <andrew@dunslane.net>:
>
>
> Pavel Stehule wrote:
>>
>> Hello
>>
>> new hstore has a very nice interface for record field iteration
>>
>>
>
> Yes, and I have used it, but it really would be nicer to have some
> introspection facilities built in, especially for use in triggers.

I am not sure. PL/pgSQL is really bad language for this task. Any
procedure developed in plpgsql should be pretty slow. Personally I am
happy with current 8.5. If some need it, the he could to use hstore -
contrib modules are not problem on every platform, but cannot generate
too much general triggers simply (what is good). I understand well to
motivation. But now I thinking, so general triggers are very bad and
risk technique and is better do things else. If someone really need
it, then he could to write C procedure.

Regards
Pavel Stehule

>
> cheers
>
> andrew
>
>
>


pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: operator exclusion constraints
Next
From: Marko Tiikkaja
Date:
Subject: Writeable CTE patch