Thread: LIBPQ: Can we have buffered PGresult (i.e. a retreival bu chuncks?)
Is there a way to break the PGresult array to chunks Like Oracle? Thanks Danny Abraham BMC Software CTM&D Business Unit 972-52-4286-513 danny_abraham@bmc.com
Il Thursday 22 November 2007 16:23:25 Abraham, Danny ha scritto: > Is there a way to break the PGresult array to chunks > Like Oracle? > > Thanks > > Danny Abraham > BMC Software > CTM&D Business Unit > 972-52-4286-513 > danny_abraham@bmc.com > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend I presume that the usal LIMIT+OFFSET solution is not OK. Right? -- Reg me Please <Non quietis maribus nauta>
"Abraham, Danny" <danny_abraham@bmc.com> writes: > Is there a way to break the PGresult array to chunks > Like Oracle? There isn't a protocol-level way but there is a way in SQL, use cursors and "FETCH FORWARD <n>" -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support!
Abraham, Danny wrote: > Is there a way to break the PGresult array to chunks > Like Oracle? Sure. Use a cursor. -- Alvaro Herrera http://www.PlanetPostgreSQL.org/ "Right now the sectors on the hard disk run clockwise, but I heard a rumor that you can squeeze 0.2% more throughput by running them counterclockwise. It's worth the effort. Recommended." (Gerry Pourwelle)