Skip site navigation (1) Skip section navigation (2)

what are the ways to avoid --- "ERROR: EXECUTE of SELECT ... INTO is not implemented yet"

From: Shantanu <shantanu(dot)gg(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: what are the ways to avoid --- "ERROR: EXECUTE of SELECT ... INTO is not implemented yet"
Date: 2008-05-30 16:27:49
Message-ID: 97d558890805300927q13c476bcv8216564af4d578ce@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Hello experts,


I am facing this error.

mydb=> select version();
                                            version

--------------------------------------------------------------------------------

 PostgreSQL 8.1.9

(1 row)

mydb=> \i /tmp/test.sql
CREATE FUNCTION
mydb=> select sp_test();
ERROR:  EXECUTE of SELECT ... INTO is not implemented yet
CONTEXT:  PL/pgSQL function "sp_test" line 4 at execute statement


mydb=>
[1]+  Stopped                 su - dbu
mymachine<root># cat /tmp/test.sql
create or replace function sp_test() RETURNS void as $$
declare
        l_var timestamp;
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

Responses

pgsql-bugs by date

Next:From: Gerardo AntonioDate: 2008-05-30 16:42:18
Subject: problems compiling in 64 bits
Previous:From: Sokolov Yura aka funny_falcon Date: 2008-05-30 09:13:18
Subject: BUG #4216: Index scan goes wrong with crosstype comparison and between in one statement

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group