Custom types as parameter in stored function

Поиск
Список
Период
Сортировка
От mephysto
Тема Custom types as parameter in stored function
Дата
Msg-id 1309167207054-4527618.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: Custom types as parameter in stored function  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-general
Hello to everyone,
I am trying to pass custom types as parameters in stored functions, and I
tried this syntax successfully:

create type myType as (id bigint, name character varying);


create or replace myfunc(obj myType)
returns void as
begin
.......
end;


select myfunc((1, 'foo')::myType;


In this manner, if I understand it, there is a positional assignment of
attribute value: id = 1 and name = foo.
My ask is is there a manner to assing value to attribute of custom type by
name instead by position.

Thanks in advance.

Mephysto.

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Custom-types-as-parameter-in-stored-function-tp4527618p4527618.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

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

Предыдущее
От: mephysto
Дата:
Сообщение: Re: Custom types as parameter in stored function
Следующее
От: Leif Biberg Kristensen
Дата:
Сообщение: Re: An amusing MySQL weakness--not!