| 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: | Whole Thread | Raw Message | 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) #
| 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 |