On Thu, 2003-09-04 at 22:13, Relaxin wrote:
> Finally, someone who will actually assume/admit that it is returning the
> entire result set to the client.
> Where as other DBMS manage the records at the server.
Is there a reason you can't use cursors (explicitely, or via ODBC if it
provides some glue on top of them) to keep the result set on the server?
http://candle.pha.pa.us/main/writings/pgsql/sgml/sql-declare.html
http://candle.pha.pa.us/main/writings/pgsql/sgml/sql-fetch.html
> The next one is the handling of BLOBS. PG handles them like no other system
> I have ever come across.
Just FYI, you can use both the lo_*() functions, as well as simple
bytea/text columns (which can be very large in PostgreSQL).
-Neil