Re: [GENERAL] anonymous record as an in parameter

2011-03-29 Thread Merlin Moncure
On Tue, Mar 29, 2011 at 8:07 AM, Maximilian Tyrtania wrote: > Hi there, > > i'd like to write a function (sql or plpgsql) that takes an anonymous record > as an in parameter. You know, kind of like (simplified): > > create function f_tablename (p_anyrecord record) returns text as > $body$ > selec

[GENERAL] anonymous record as an in parameter

2011-03-29 Thread Maximilian Tyrtania
Hi there, i'd like to write a function (sql or plpgsql) that takes an anonymous record as an in parameter. You know, kind of like (simplified): create function f_tablename (p_anyrecord record) returns text as $body$ select $1.tableoid::regclass::text $body$ language sql; ...but PG 9.0.3 doesn't