Re: select into

On Friday 24 November 2006 08:17 pm, Mulham freshcode wrote:
> Hi Adrian,
>
> I have number of similar tables that have different number of fields
> (similar in functionality). An in my stored procedure am trying to select a
> row from one of these tables (that i don't know in advance, hence the use
> of record) and return the data in the form of a table that has
> column_name:value pairs. where column name is that from the original table.
> I have no problem finding the column names but I don't know how to say
> data[column_name] to get the corresponding value. Is there a way to do it
> in pgsql?
>
> here is my code so far
>
>     sql_str1 = 'select * from ' || svc_tbl_name || ' where uid = ' ||
> sub_id ;
>
>     for svc_data_rec in execute sql_str1 loop
>     end loop;
>
>     -- get service_user table's column names
>     for col_name in select column_name
>             from information_schema.columns
>             where table_name~svc_tbl_name loop
>
>             raise notice 'Column name:%', col_name.column_name;
>             raise notice 'Value: %', svc_data_rec[col_name.column_name];
>
>     end loop;
>
> Thank you,
>
> Mustafa ...
>
I am afraid I can't make it work either. 
-- 
Adrian Klaver    
aklaver@comcast.net