[GENERAL] declare cursor with hold+fetch count vs PQsendQuery+PQsetSingleRowMode - resource consumption and the efficiency

2015-01-05 Thread sftf
Hello! I would like to use "pagination" in my intranet client app. My aims: - allow user to open and scroll large lists from query (without narrowing the query) - at the same time minimize time until the showing of large lists to the user - and at the same time minimize backend-frontend t

Re: [GENERAL] Declare Cursor

2007-10-11 Thread Rodrigo Gonzalez
Bob Pawley escribió: The documentation states that PostgreSQL does not support updating data via a cursor. Has that changed in the last little while. Bob Pawley I think that is in 8.3 beta, take a look to release notes smime.p7s Description: S/MIME Cryptographic Signature

[GENERAL] Declare Cursor

2007-10-11 Thread Bob Pawley
The documentation states that PostgreSQL does not support updating data via a cursor. Has that changed in the last little while. Bob Pawley