Question about passing User defined types to functions

Поиск
Список
Период
Сортировка
От David Durst
Тема Question about passing User defined types to functions
Дата
Msg-id 33664.216.86.192.34.1043921897.squirrel@www.la-rubber.com
обсуждение исходный текст
Ответы Re: Question about passing User defined types to functions
Список pgsql-sql
is there a example on how to pass user defined types into
a function??

What I am looking for is something of this nature.

CREATE TYPE dumby_type AS (dumby_id int4, dumby_name text);

create function kick_dumby(dumby dumby_type) returns INTEGER AS '
DECLARE somenumber integer;
BEGIN return 1;
END;
' language 'plpgsql';


Is there some way of doing this, because the above doesn't work.




В списке pgsql-sql по дате отправления:

Предыдущее
От: Tony Simbine
Дата:
Сообщение: Re: help: triggers
Следующее
От: val@webtribe.net
Дата:
Сообщение: Delete 1 Record of 2 Duplicate Records