Re: [GENERAL] Limits on PostgreSQL

2000-05-25 Thread Tom Lane
Marcos Barreto de Castro <[EMAIL PROTECTED]> writes: > 1 - How many tuples can be returned as a result of a > query using a CURSOR? (Is it possible to do a SELECT > * on a table that has 2 million records and OPEN a > CURSOR for that SELECT and show all records'contents > using FETCH FORWARD, for

[GENERAL] Limits on PostgreSQL

2000-05-25 Thread Marcos Barreto de Castro
Hi, I am developing an application that will use the C API for postgreSQL and I need to know this: 1 - How many tuples can be returned as a result of a query using a CURSOR? (Is it possible to do a SELECT * on a table that has 2 million records and OPEN a CURSOR for that SELECT and show all r