Postgres Pro
Downloads
Home   >   mailing lists

Stepping through a table. - Mailing list pgsql-sql

From Matthew Hagerty
Subject Stepping through a table.
Date
Msg-id 4.1.19990815225433.00cb6c20@mail.venux.net
Whole thread Raw
Responses Re: [SQL] Stepping through a table.  (Herouth Maoz <herouth@oumail.openu.ac.il>)
List pgsql-sql
Tree view 
Greetings,

If I need to process each record in a table, how can I step through each
record?  I suppose I could write a query to return all records and fetch
each row that way, but that would be a big memory pig, no?  Also, the table
could get pretty big.  Is there some way to navigate a table, maybe
fetching one record from the disk at a time, or something similar?

Thanks,
Matthew Hagerty

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] Agregate Problem?
Next
From: wieck@debis.com (Jan Wieck)
Date:
Subject: Re: [SQL] new.oid not working inside rule [repost]