Обсуждение: [pgsql-www] writing functions with return type record

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 table mydummytable
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

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