"Ehab Galal" <ehabgalal123(at)hotmail(dot)com> writes:
> 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
The systable_xxx functions allow implementation by either indexscan or
seqscan, therefore they guarantee *nothing* about retrieval order.
If your code does not need to be executed during bootstrap or crash
recovery, you could depend on an indexscan instead. See
toast_fetch_datum() for an example.
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Mark Kirkwood||Date: 2006-11-27 05:22:39|
|Subject: Re: [PATCHES] Avg performance for int8/numeric|
|Previous:||From: Tom Lane||Date: 2006-11-27 05:10:03|
|Subject: Re: [CORE] RC1 blocker issues |