Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: How do I detect End-of-table or End-of-limit ?
- From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
- To: Jan van der Weijde <Jan(dot)van(dot)der(dot)Weijde(at)attachmate(dot)com>
- Cc: pgsql-interfaces(at)postgresql(dot)org
- Subject: Re: How do I detect End-of-table or End-of-limit ?
- Date: Thu, 11 Jan 2007 21:36:41 -0300
Jan van der Weijde wrote: > However I am looking for something more elegant like a status flag in > libpq that indicate EOF or End-Of-limit. I don't think there's an actual "EOF". What you see is an "end of tuples in the result set". Whether it is because you ran into the LIMIT, or because you fell off the end of the table, you can't tell (nor can the server actually). Maybe it's more appropriate for you to open a cursor for the whole table, and then do FETCH from it until it runs out of tuples; you will know then that it's the end of the table. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.
- References:
- How do I detect End-of-table or End-of-limit ?
- From: Jan van der Weijde
- How do I detect End-of-table or End-of-limit ?
- Prev by Date: How do I detect End-of-table or End-of-limit ?
- Next by Date: Re: How do I detect End-of-table or End-of-limit ?
- Previous by thread: How do I detect End-of-table or End-of-limit ?
- Next by thread: Re: How do I detect End-of-table or End-of-limit ?
- Indexes: