Function with record type as argument

Поиск
Список
Период
Сортировка
Искать
От
Sean Davis
Тема
Function with record type as argument
Дата
Msg-id
009E963D-84CD-11D9-A6C7-000D933565E8@mail.nih.gov
Список
Дерево обсуждения
Function with record type as argument Sean Davis <sdavis2@mail.nih.gov>
Re: Function with record type as argument Tom Lane <tgl@sss.pgh.pa.us>
Re: Function with record type as argument Sean Davis <sdavis2@mail.nih.gov>
Re: Function with record type as argument Tom Lane <tgl@sss.pgh.pa.us>
Re: Function with record type as argument Sean Davis <sdavis2@mail.nih.gov>
In a followup to an earlier question from today from another person, is 
it possible to create and use a function that takes as input a generic 
"record"?  Specifically, how would I use a function like:

create or replace function perl_columns(record) returns text as $a$
	my ($rec)=@_;
	my $xml_ex = '';
	foreach my $tag (keys %$rec) {
		$xml_ex = "<$tag>" . $rec->{$tag} . "\n";
	}
	return $xml_ex;
$a$ language plperlu;

Thanks,
Sean

В списке pgsql-novice по дате отправления
От: john-paul delaney
Дата:
Сообщение: Re: Query combination query.
От: SG Edwards
Дата:
FAQ