record_inspect.git - A set of functions to inspect values of type RECORD from SQL and PLPGSQL. The goal is better support for writing generic trigger functions in PLPGSQL. Currently, these two functions exist: record_fields(record) returns name[] Returns the names of all the record's fields. record_value(record, fieldname name, default anyelement) returns anyelement Returns the value of the field <fieldname>, converted to the type of the <default> argument. If the field contains NULL, <default> is returned instead. My hope is that this will eventually become either part of postgres proper or a contrib module.

A set of functions to inspect values of type RECORD from SQL and PLPGSQL. The goal is better support for writing generic trigger functions in PLPGSQL. Currently, these two functions exist: record_fields(record) returns name[] Returns the names of all the record's fields. record_value(record, fieldname name, default anyelement) returns anyelement Returns the value of the field <fieldname>, converted to the type of the <default> argument. If the field contains NULL, <default> is returned instead. My hope is that this will eventually become either part of postgres proper or a contrib module.

git repository user

summary refs log tree commit diff

Repository seems to be empty

Clone