One thing you might be missing is that indexes are relations too. They're a
bit different than heap relations (ie "tables") but they share enough
structure that it's worth using the same datatypes to represent both.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me
take a look at that ...
http://www.postgresql.org/docs/8.3/static/indexam.html
this might clear up the problem.
here is an example making clear what happens:
select phone_number from phonebook where name = 'xy';
index is asked to find the right place in the heap to retrieve the data.
t
Hans-Juergen Schoenig <[EMAIL PROTECTED]> wrote:
On Feb 17, 2008, at 4:33 PM, Suresh wrote:
[ "include/access/relscan.h" ]
In IndexScanDescData, whats the purpose of having two Relation variables.
typedef struct IndexScanDescData
{
RelationheapRelation; /* heap relation des
On Feb 17, 2008, at 4:33 PM, Suresh wrote:
[ "include/access/relscan.h" ]
In IndexScanDescData, whats the purpose of having two Relation
variables.
typedef struct IndexScanDescData
{
RelationheapRelation; /* heap relation
descriptor, or NULL */
Relation
[ "include/access/relscan.h" ]
In IndexScanDescData, whats the purpose of having two Relation variables.
typedef struct IndexScanDescData
{
RelationheapRelation; /* heap relation descriptor, or NULL */
RelationindexRelation; /* index relation descriptor */
...