From: | mephysto <gennaria(at)email(dot)it> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Custom types as parameter in stored function |
Date: | 2011-06-27 09:33:27 |
Message-ID: | 1309167207054-4527618.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | mephysto | 2011-06-27 09:47:44 | Re: Custom types as parameter in stored function |
Previous Message | Dean Rasheed | 2011-06-27 08:10:31 | Re: Reusing cached prepared statement slow after 5 executions |