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

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

On Sat, May 31, 2008 at 10:51:35PM +0530, Shantanu wrote:
> Here is my real use case
>
> 1) We have nornal SELECT ...INTO calls in the procedure calls
> 2) However we landed ourselves with the following problem
> http://www.postgresql.org/docs/faqs.FAQ.html#item4.19

[...]

> Any alternatives ?

Well -- according to the 8.1 docs (I don't have an 8.1 around at the
moment, sorry), one of my proposals should work:

> On Sat, May 31, 2008 at 8:38 AM, <tomas(at)tuxteam(dot)de> wrote:
>

[...]

> > 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;

[...]

(see <http://www.postgresql.org/docs/8.1/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN>).

Did you try that? Did it work?

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

iD8DBQFIQ6LIBcgs9XrR2kYRAnDHAJsEz/SS7o/sIwy7dqSGSKpeVhOLlQCfetQM
GSbMIG2s7DUPOIpN6xDKocQ=
=Cb8o
-----END PGP SIGNATURE-----