dinar(at)yantel(dot)ru writes:
> declare
> hosts_str mail_relayhosts%ROWTYPE;
> ...
> FOR hosts_str IN SELECT hosts from mail_relayhosts LOOP
You would need SELECT * FROM here, if you're selecting the whole row.
This is going to try to stuff "hosts" into the first column of the
rowtype variable, which is the wrong datatype. (I think it would then
complain about too few columns supplied, but it's not getting that far.)
regards, tom lane