Обсуждение: plpgsql -record in -record out

Поиск
Список
Период
Сортировка

plpgsql -record in -record out

От
"Adam Walczykiewicz"
Дата:
This message was sent from Geocrawler.com by "Adam Walczykiewicz" <adam.walczykiewicz@multiuser.com.pl>
Be sure to reply to that address.

Hi
Is possible to send a record(more than 8 fields) 
to the function
in plpgsql then modified it and send back???
I've tried:... 
CREATE FUNCTION modrec(rec_client) RETURNS 
rec_client)
(...)
and call itSELECT modrec
(name::rec_client,age::rec_client..._)

but it failed. The only method I found
is to send record as a text and exctract it inside
,modified and send back as a text.
Thanks for any sugesstions.
Adam


Geocrawler.com - The Knowledge Archive