Re: [SQL] record type

2008/7/10 Marcin Krawczyk <jankes.mk@gmail.com>:

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
pawel.socha@gmail.com

programista/administrator

perl -le 's**02).4^&-%2,).^9%4^!./4(%2^3,!#+7!2%^53%2&**y%& -;^[%"`-{ a%%s%%$_%ee'