If you only need the count when you've got the results, most PG client
interfaces will tell you how many rows you've got. What language is your app
in?
PHP.
But I have only a subset of the results, retrieved via a query with a LIMIT
m clause, so $pg_numrows is m.
And retrieving all results
Spiegelberg, Greg kirjutas P, 11.01.2004 kell 18:21:
It would seem we're experiencing somthing similiar with our scratch
volume (JFS mounted with noatime).
Which files/directories do you keep on scratch volume ?
All postgres files or just some (WAL, tmp) ?
-
Hannu
Hannu Krosing wrote:
Spiegelberg, Greg kirjutas P, 11.01.2004 kell 18:21:
It would seem we're experiencing somthing similiar with our scratch
volume (JFS mounted with noatime).
Which files/directories do you keep on scratch volume ?
All postgres files or just some (WAL, tmp) ?
No Postgres
On Mon, 2004-01-12 at 10:37, David Shadovitz wrote:
If you only need the count when you've got the results, most PG client
interfaces will tell you how many rows you've got. What language is your app
in?
PHP.
But I have only a subset of the results, retrieved via a query with a LIMIT
m
Dear developers,
I wonder it happens to systems where inefficient update
SQL's are used like this:
UPDATE MyTable SET MyColumn=1234
Question arises when the value of MyColumn is already 1234
before the update.
If I am right, even when the to-be-updated column values
equal to the new values,