Re: HeapTuple layout - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: HeapTuple layout
Date
Msg-id 10759.1015521346@sss.pgh.pa.us
Whole thread Raw
In response to HeapTuple layout  (Michael Klatt <mdklatt@ou.edu>)
List pgsql-interfaces
Michael Klatt <mdklatt@ou.edu> writes:
> Is a HeapTuple for a particular table guaranteed to have the same layout
> (order and number of attributes) as that table?

Define what you mean by "for a table".  If it's actually intended to be
stored in the table then it had better have the right layout.  A tuple
read from a table will have the expected layout but may be missing
columns at the end (in case it hasn't been updated since an ALTER TABLE
ADD COLUMN command).  The standard tuple access routines treat this case
as meaning that the missing columns are NULLs.

> Also, is a HeapTuple used to store the tuples in a PGresult?

No, HeapTuples are only used inside the backend.
        regards, tom lane


pgsql-interfaces by date:

Previous
From: anil
Date:
Subject: Re: Beating Oracle
Next
From: Mark Johannessen
Date:
Subject: pgsql_perl5-1.9.0 install problem