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
