2008/7/10 Marcin Krawczyk <[EMAIL PROTECTED]>: > Hi. I need to know whether it's possible for a plpgsql function to accept > record type parameters ? Is there a way to accomplish that ? > I need to use something like ('1','2','3') as a parameter. > > regards > mk >
All about record type http://www.postgresql.org/docs/8.3/interactive/plpgsql-declarations.html#PLPGSQL-DECLARATION-RECORDS section 38.3.4 but, try this ;-) merlin=# create table your_table(col1 int, col2 varchar(12), col3 int); CREATE TABLE merlin=# create or replace function test_1(val_of your_table) returns void as $$ declare begin insert into your_table values(val_of.col1, val_of.col2, val_of.col3); end; $$ LANGUAGE plpgsql; CREATE FUNCTION CREATE FUNCTION merlin=# select test_1((1,'test',2)); test_1 -------- (1 row) merlin=# select * from your_table ; col1 | col2 | col3 ------+------+------ 1 | test | 2 (1 row) Time: 0.380 ms -- -- Serdecznie pozdrawiam Pawel Socha [EMAIL PROTECTED] programista/administrator perl -le 's**02).4^&-%2,).^9%4^!./4(%2^3,!#+7!2%^53%2&**y%& -;^[%"`-{ a%%s%%$_%ee'