EXECUTE…USING statement in PL/pgSQL doesn't work with record type?

It's true. You cannot to use type record outside PL/pgSQL space RECORD value is valid only in plpgsql you can do EXECUTE 'SELECT $1. Descr' INTO d USING r::text::xx.

It's true. You cannot to use type record outside PL/pgSQL space. RECORD value is valid only in plpgsql.

You can do EXECUTE 'SELECT $1. Descr' INTO d USING r::text::xx.

Your code doesn't work. – Hobbes Jan 21 '10 at 8:03 1 Ok sorry obviously your code works by replacing 'xx' with 'table1'. But that way I can't dinamically specify the table name.So the right answer is: "EXECUTE 'SELECT $1::text::table1.

Descr' INTO d USING r;". THANKS A LOT! – Hobbes Jan 21 '10 at 8:34.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions