Nice thanks a lot. Niezłe, dzieki. regards pozdrowienia mk
2008/7/11 Pawel Socha <[EMAIL PROTECTED]>: > > > 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'