Re: cursor in plpgsql - Mailing list pgsql-general

From wieck@debis.com (Jan Wieck)
Subject Re: cursor in plpgsql
Date
Msg-id m12cPH7-0003l8C@orion.SAPserv.Hamburg.dsh.de
Whole thread Raw
In response to cursor in plpgsql  ("Grigoriy G. Vovk" <vovk@sled.rpa.ryazan.su>)
List pgsql-general
[Charset koi8-r unsupported, filtering to ASCII...]
> Sorry for my bad english!
>
> Can I use "DECLARE CURSOR" in plpgsql function?

    No,  it's  impossible and yes, that's bad because the backend
    has to load the entire result set into memory.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#========================================= wieck@debis.com (Jan Wieck) #



pgsql-general by date:

Previous
From: Jim Richards
Date:
Subject: Re: SELECT speed with LIKE
Next
From: Lincoln Yeoh
Date:
Subject: Re: How to speed up commits?