Stepping through a table.

Поиск
Список
Период
Сортировка
От Matthew Hagerty
Тема Stepping through a table.
Дата
Msg-id 4.1.19990815225433.00cb6c20@mail.venux.net
обсуждение исходный текст
Ответы Re: [SQL] Stepping through a table.  (Herouth Maoz <herouth@oumail.openu.ac.il>)
Список pgsql-sql
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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] Agregate Problem?
Следующее
От: wieck@debis.com (Jan Wieck)
Дата:
Сообщение: Re: [SQL] new.oid not working inside rule [repost]