Re: Add items to a record variable

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