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

Re: cursor question

From: Andreas Wenk <a(dot)wenk(at)netzmeister-st-pauli(dot)de>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: cursor question
Date: 2009-02-25 17:51:51
Message-ID: 49A58537.6020608@netzmeister-st-pauli.de (view raw or flat)
Thread:
Lists: pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Pavel Stehule schrieb:
> Hello
> 
> when you would to change name of table - you have to use dynamic query
> 
> 38.7.2.2. OPEN FOR EXECUTE
> 
> OPEN unbound_cursor [ [ NO ] SCROLL ] FOR EXECUTE query_string;
> 
> 
> http://www.postgresql.org/docs/8.3/interactive/plpgsql-cursors.html
> 
> regards
> Pavel Stehule

Hi Pavel,

thanks a lot. It works for me like this:

CREATE OR REPLACE FUNCTION user_cursor_test(refcursor,text) RETURNS refcursor AS $$
BEGIN
        OPEN $1 FOR EXECUTE 'SELECT name FROM ' || $2;
        RETURN $1;
END; $$ LANGUAGE plpgsql;

Cheers

Andy


> 2009/2/25 Andreas Wenk <a(dot)wenk(at)netzmeister-st-pauli(dot)de>:
> Hi,
> 
> short question. Why is this not possible:
> 
> CREATE OR REPLACE FUNCTION user_cursor_open(text) RETURNS refcursor AS $$
> DECLARE
>        curs1 CURSOR FOR SELECT * FROM $1;
> BEGIN
>        OPEN curs1;
>        RETURN curs1;
> END; $$ LANGUAGE plpgsql;
> 
> Or, how do I set a parameter when using cursor?
> 
> Thanks in advance
> 
>>
- --
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
>>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJpYU2Va7znmSP9AwRAgGAAJ9En2TEupu7t994DIxi9ql5LH5sXACdHIi1
jNiaLX2mEmYWRxHDcGavbsM=
=XUcF
-----END PGP SIGNATURE-----

In response to

pgsql-general by date

Next:From: Joshua D. DrakeDate: 2009-02-25 18:10:54
Subject: Re: Warm standby failover mechanism
Previous:From: Dave PageDate: 2009-02-25 17:16:18
Subject: Re: [GENERAL] speaking of 8.4...

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