How to manipulate tuples in C functions?

From: a <372660931(at)qq(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: How to manipulate tuples in C functions?
Date: 2018-05-07 20:20:16
Message-ID: tencent_4D3931CA0E0CFAE14D86AA55@qq.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hey all:

As far as I know, composite type and rows (trigger functions) are passed between PostgreSQL and C functions as tuple. However, I rarely find things relating on how to manipulate a tuple under C from documentation.

The only thing I can find from the doc is very simple stuff like 'GetAttributeByName' or 'GetAttributeByNum' to retrieve data, or use a 'BlessTupleDesc' to initialize a 'TupleDesc' variable and 'heap_form_tuple' to return a 'HeapTuple' and return a 'HeapTupleGetDatum(HeapTuple tuple)' to convert to a 'Datum' type.

However not only the illustration of the previous listed functions are not fully described (e.g. return and input of each functions) but also any complex situation are stated. What if I have a composite type inside a composite type? What if I have a array inside a composite type? What if I have a variable length type?

Furthermore, to write a compatible procedures, I would need at least 2 more information: 1, The total number of entry inside a tuple; 2, The total space the tuple took.

So if anyone can tell me how to answer the above question? Or simply give an example of iterator that go through all entries of a tuple? Thank you so much!!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Gauthier 2018-05-07 21:35:49 Run external command as part of an sql statement ?
Previous Message Ben Chobot 2018-05-07 18:04:31 Re: Renice on Postgresql process