Re: Building a record in a function - Mailing list pgsql-general

Robert Fitzpatrick wrote:
> Haven't done a whole lot of plsql returning records, only those based on
> a query. I was wondering, can I build a record from the results of the
> query using other values for some fields in the record? I know 'return
> next' requires a record and want to build my own record to include some
> argument values in the record. I have my record declared and my query
> results in that record. So, how do you construct a record in a function?
> Below is my work...
>
>   period := $1;
>   rep := $2;
>   FOR dateval IN SELECT (period::date+(s||'month')::interval)::date from generate_series(0,11)s
>   loop
>     SELECT INTO picks
>       COUNT(public.view_pick_1_data.units)::numeric AS units,
    CURRENT_DATE AS "date",
    'x'::text AS some_text_field

That's the simplest way.
Alternatively, you can use CREATE TYPE to make the required row-type and
fill a variable of that type.
--
   Richard Huxton
   Archonet Ltd