Re: [pgsql-www] writing functions with return type record

Hi Roberto,

This is probably not the mailing list you're after.  This one is for
people doing stuff with the PostgreSQL website infrastructure.

At a guess, you're probably after the "pgsql-general" mailing list
instead.  Sorry for having to bounce you around. ;)
 https://www.postgresql.org/list/pgsql-general/

Subscribe here:
 https://www.postgresql.org/community/lists/subscribe/

Regards and best wishes,

Justin Clift


> On 14 Feb 2017, at 15:24, Roberto Bellandi <roberto@b2tel.it> wrote:
>
> Hi, i'am try to encapsulate some logic into funtions to clear design,
>
> my question is:
>
> CREATE OR REPLACE FUNCTION get_something(various param)
>  RETURNS SETOF mydummytable AS
> $BODY$
> DECLARE
>    v_rec    mydummytable%rowtype;
> BEGIN
> FOR v_rec IN (select field1, field2 blabla)
> LOOP
> RETURN NEXT v_rec;
>    END LOOP;
>    RETURN;
> END;
> $BODY$
>  LANGUAGE plpgsql VOLATILE
>  COST 100
>  ROWS 1000;
>
> with mydummytable a real empty table
> i can use function in query like this
>
> select field1 from get_something(...)
>
> without creation of table mydummytable and use in function type RECORD
>
> i can use
> select field1 from get_something(...)a (field1 type, field2 type,...)
>
> is possible and if yes how to write function return rowset  or where store  mydummytable structure without create
tablemydummytable 
> and use function in query like this  select field1 from get_something(...) without     a (field1 type, field2
type,...)definition 
>
> PS i read about resultset fully retrieve , my query in function at maximum return one or two row
>
>
>
>
> --
> Sent via pgsql-www mailing list (pgsql-www@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-www

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi