Re: [BUGS] Record type and ROW type in pl/pgsql functions

#1

dinar (AT) yantel (DOT) ru writes:

Quote:

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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] Record type and ROW type in pl/pgsql functions

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] Record type and ROW type in pl/pgsql functions - 04-20-2004 , 07:45 AM