Re: enumerating rows - Mailing list pgsql-sql

From Josh Berkus
Subject Re: enumerating rows
Date
Msg-id web-36920@davinci.ethosmedia.com
Whole thread Raw
In response to Re: enumerating rows  (Kovacs Zoltan <kovacsz@pc10.radnoti-szeged.sulinet.hu>)
List pgsql-sql
Kovacs, Oliver,
First, thank you Oliver for the nice C program for this purpose.  If
there doesn't turn out to be another method, it shoudl og in the
postgresql.org site.
However, Postgresql does have an internal row count for query results.
Otherwise LIMIT and OFFSET would not work.  It seems like there should
be some way to access this internal row count.
                -Josh

______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco
 


pgsql-sql by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Making SELECT COUNT(seed) FROM fast
Next
From: "Oliver Elphick"
Date:
Subject: Re: enumerating rows