mestamp;
begin
execute 'SELECT NOW() INTO l_var';
end;
$$ language plpgsql;
What are the ways to avoid it
We have an idea of creating the temporary table to store the cursor values,
but this would require a huge effort.
Any alternatives?
~
Shantanu
lement is the EXECUTE command one.
This is causing the SELECT ...INTO problem
Upgrade is not an option :(
Currently the only available solution is
Use a temporary table where we write the local variable and make it read
from the table .
Any alternatives ?
~
Shantanu
On Sat, May 31, 2008 at 8:3
lement is the EXECUTE command one.
This is causing the SELECT ...INTO problem
Upgrade is not an option :(
Currently the only available solution is
Use a temporary table where we write the local variable and make it read
from the table .
Any alternatives ?
~
Shantanu
On Sat, May 31, 2008 at 10
