Re: Add items to a record variable

The first hack is probably a little easier. Let me try and flesh it
out for you:

declare
rec1 record;
rec2 record;
new_fields varchar = '';

begin
select fieldlist from mytable into rec1;
-- inspect and play with your rec1 here
-- now start a loop to add new fields

if new_fields != '' then
new_fields = new_fields || ', '
end if;

new_fields = new_fields || new field value here || '::' || new
field type here;

-- close loop here

-- now select all rows into a new record variable

execute 'select mt.fieldlist ' || new_fields || ' from mytable mt into rec2';

end;

This is a hack but it should work. You'll end up with a single record
var with your old fields and new fields, typed as you have specified.

On 3/1/07, Eddy D. Sanchez <eddy(dot)sanchez(at)gmail(dot)com> wrote:
> Good idea, thanks a lot, I try it
>
> On Mar 2, 2007, at 1:32 AM, Postgres User wrote:
>
> > Ok, you can always SELECT into a temp table. If you want to add
> > additional fields in a loop, you can call an Execute 'Alter Table Add
> > Column....'
> > to add all the fields you need. Then call Update to insert values
> > into the fields.
> >
> > Finally do a select into your record var.
> >
> > On 3/1/07, Eddy D. Sanchez <eddy(dot)sanchez(at)gmail(dot)com> wrote:
> >> Thanks.
> >>
> >> But I need to add fields to a defined and filled record, I don't know
> >> if I can do it, and how can I do it.
> >>
> >> If I have:
> >>
> >> v_record record;
> >>
> >> EXECUTE 'select * from table'
> >> INTO v_record;
> >>
> >> supposing (after query) that v_record contains just one row with 5
> >> fields, I need to add the 6th, 7th, 8th fields, etc, etc.
> >>
> >> Do you understand ?
> >>
> >>
> >>
> >> On Mar 2, 2007, at 12:48 AM, Postgres User wrote:
> >>
> >> > If you need to return a record to another function or client
> >> program,
> >> > you can always use this sytnax:
> >> >
> >> > SELECT var_a::integer, var_b::integer, var_c::integer... etc
> >> >
> >> > where var_a, var_b, etc and local variables that hold your
> >> > calculated values.
> >> >
> >> > You dont need to create a local record structure- select will do
> >> that
> >> > for you. The '::integer' will ensure that the values are
> >> typecast as
> >> > integers.
> >> >
> >> >
> >> > On 3/1/07, eddy sanchez <eddysan(at)udabol(dot)edu(dot)bo> wrote:
> >> >> WEBMAIL Server: UDABOLnet, Universidad de Aquino Bolivia
> >> >>
> >> >> Thank you for you help
> >> >>
> >> >> The item is a field, I need to return a record with double
> >> >> precision or integer
> >> >> fields.
> >> >>
> >> >> I need a function that can calculate some fields (integer numbers)
> >> >> that should
> >> >> be added to a record inside a loop, and the result, must seems
> >> >> like this:
> >> >>
> >> >> {234.00, 56434.78, 5556.89,....}
> >> >>
> >> >> Always, I call those functions with:
> >> >>
> >> >> select * from func_with_record() as (field1 integer, field2
> >> >> integer, field3
> >> >> integer,....)
> >> >>
> >> >> Do you undestand?
> >> >>
> >> >> Thanks a lot for your interesting.
> >> >>
> >> >>
> >> >>
> >> >> -----------------------------------
> >> >>
> >> >> What is the new item? Is it a field?
> >> >>
> >> >> On 3/1/07, eddy sanchez <eddysan(at)udabol(dot)edu(dot)bo> wrote:
> >> >> WEBMAIL Server: UDABOLnet, Universidad de Aquino Bolivia
> >> >>
> >> >>
> >> >> Can anyone help me???
> >> >>
> >> >> I work with plpgsql and I need to add items to a record variable,
> >> >> with a for
> >> >> statement, something like this:
> >> >>
> >> >> declare
> >> >> v_rec record;
> >> >> begin
> >> >> for nn in (some_xpresion) loop
> >> >> ....
> >> >>
> >> >> v_rec = vrec + [new_item]; <--Here I need to add an item to record
> >> >> variable with
> >> >> each loop
> >> >> end loop lp;
> >> >>
> >> >> return v_rec;
> >> >> end;
> >> >>
> >> >>
> >> >> The result should be like {it1,it2,it3,i4,....}
> >> >>
> >> >> Please can you help me?
> >> >> Thanks a lot
> >> >>
> >> >> -------------------------------------------------
> >> >> Este email se envio mediante el servidor WEBMAIL de UDABOLnet
> >> >> -------------------------------------------------
> >> >>
> >> >> ---------------------------(end of
> >> >> broadcast)---------------------------
> >> >> TIP 1: if posting/reading through Usenet, please send an
> >> appropriate
> >> >> subscribe-nomail command to majordomo(at)postgresql(dot)org so that
> >> >> your
> >> >> message can get through to the mailing list cleanly
> >> >>
> >> >>
> >> >>
> >> >> -------------------------------------------------
> >> >> Este email se envio mediante el servidor WEBMAIL de UDABOLnet
> >> >> -------------------------------------------------
> >> >>
> >>
> >>
>
>