Re: cursor in plpgsql

From: wieck(at)debis(dot)com (Jan Wieck)
To: "Grigoriy G(dot) Vovk" <vovk(at)sled(dot)rpa(dot)ryazan(dot)su>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: cursor in plpgsql
Date: 2000-04-04 09:05:29
Message-ID: m12cPH7-0003l8C@orion.SAPserv.Hamburg.dsh.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)debis(dot)com (Jan Wieck) #

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lincoln Yeoh 2000-04-04 09:16:39 Re: How to speed up commits?
Previous Message Andrew C.R. Martin 2000-04-04 09:04:20 Re: [ANNOUNCE] PostgreSQL book completed though chapter 10