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

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Fri, May 30, 2008 at 09:57:49PM +0530, Shantanu wrote:
> 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';
^^^^^^^^^^^^^^^^^^

Why do you need execute '...' at all? Why not directly do instead

SELECT NOW() into l_var;

What is your "real" use case?

Note that if you really need the dynamic command, you might put its
result int a variable, like so:

EXECUTE 'SELECT NOW()' INTO l_var;

...but if we don't know what you are trying to achieve, it's difficult
to provide meaningful recommendations.

Regards
- -- tomás
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFIQMEjBcgs9XrR2kYRAnaWAJ9Mpu/qvqzi911yiftbe3lLYZiyLgCfcWIl
TKs78mgZiKFRZcHnmHMQnOw=
=I2iD
-----END PGP SIGNATURE-----