Hi guys,
Am new to sql scripting so this might be a stupid question. Am getting an
error while trying to do the following
SELECT INTO svc_data_rec * from svc_tbl_name where 'uid' = sub_id;
where svc_data_rec is defined as record and svc_tbl_name is a varchar that
holds the name of a table
h the
result's structure automatically)." That i take to mean that the above is ok.
But it ain't.
Thanks again for your guys help...
"A. Kretschmer" <[EMAIL PROTECTED]> wrote: am Wed, dem 22.11.2006, um 0:28:15
-0800 mailte Mulham freshcode folgendes:
>
will be no point in using it since I
need something to change according the structure the table, which i don't know
in advance...
Thank you,
Mustafa...
Adrian Klaver <[EMAIL PROTECTED]> wrote: On Thursday 23 November 2006 09:19 am,
Mulham freshcode wrote:
> Hi,
> Thanks ve
cuting the
statement?
Sorry for the long question,
and thanks again for the help
Mustafa...
Tom Lane <[EMAIL PROTECTED]> wrote: Mulham freshcode writes:
> execute sql_str1 into svc_data_rec ;
> svc_data_rec is a RECORD, which is supposed to be dynamic.
This should work --- in PG 8
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 ...
Adrian Klaver <[EMAIL PROTECTED]> wrote: On Thursday 23 November
Hi Adrian,
Thanks very much for your help...it is a pity you can't do this in plpgsql coz
i have almost every thing else I need, and I hate to use yet another language.
What does it take to add this mechanism to the language? Is any one planning to
add it? It can come it handy I bet.
Thanks ag
