system table scan

Поиск
Список
Период
Сортировка
От Ehab Galal
Тема system table scan
Дата
Msg-id BAY24-F2671724D581180B31D388796E60@phx.gbl
обсуждение исходный текст
Ответы Re: system table scan  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi,
I created an additional system table that i need in my system. The table 
contains attributes (username, att1, att2, ...)
I need to scan the table for a certain username while retrieving the tupled 
ordered by att1.

If i understand correctly, i may use systable_beginscan() and 
systable_getnext() to scan a system table while specifying a key (e.g., 
username='user1'). But i know nothing about specifying the order of the 
scan.

Should i implement my own table scan functions then? Or there is any 
mechanism that i may reuse?

Thanks a lot,
Ehab

_________________________________________________________________
All-in-one security and maintenance for your PC.� Get a free 90-day trial! 

http://clk.atdmt.com/MSN/go/msnnkwlo0050000002msn/direct/01/?href=http://clk.atdmt.com/MSN/go/msnnkwlo0050000001msn/direct/01/?href=http://www.windowsonecare.com/?sc_cid=msn_hotmail



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [PATCHES] Avg performance for int8/numeric
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: [CORE] RC1 blocker issues