system table scan

From: "Ehab Galal" <ehabgalal123(at)hotmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: system table scan
Date: 2006-11-27 04:32:32
Message-ID: BAY24-F2671724D581180B31D388796E60@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2006-11-27 04:42:26 Re: [CORE] RC1 blocker issues
Previous Message Tom Lane 2006-11-27 03:55:58 Re: [PATCHES] Avg performance for int8/numeric