plpgsql -record in -record out

From: "Adam Walczykiewicz" <archiver(at)db(dot)geocrawler(dot)com>
To: pgsql-hackers(at)hub(dot)org
Subject: plpgsql -record in -record out
Date: 2000-01-18 02:04:55
Message-ID: 200001180204.SAA10563@www.geocrawler.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

This message was sent from Geocrawler.com by "Adam Walczykiewicz" <adam(dot)walczykiewicz(at)multiuser(dot)com(dot)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 it
SELECT 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

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Lockhart 2000-01-18 02:29:54 Re: [HACKERS] Re: [COMMITTERS] pgsql/src/include/catalog (pg_type.h)
Previous Message Hiroshi Inoue 2000-01-18 01:02:31 How to ignore system indexes