Accessing composite type columns from C

Reg Me Please <regmeplease@gmail.com> writes:

Is there a way with the libpq to access "subcolumns" in a composite type
column?

libpq knows nothing in particular about composite columns. You'd need
to parse out the data for yourself, per the syntax rules at
http://www.postgresql.org/docs/8.2/static/rowtypes.html#AEN5986

Depending on what you're doing, it might be better to expand the
column at the server side, ie, "SELECT (ccol).* FROM ..."

regards, tom lane

On Jan 17, 2008 5:48 AM, Reg Me Please <regmeplease@gmail.com> wrote:

Hi all.
Is there a way with the libpq to access "subcolumns" in a composite type
column?
The documentation (8.2) seems not to mention this case.
Thanks.
--

We have a proposal to do this for 8.4. We will probably maintain this
outside of the project for the 8.3 cycle (and it could be adapted to
8.2 very easily). See:

http://archives.postgresql.org/pgsql-hackers/2008-01/msg00257.php

merlin