Re: Accessing composite type columns from C - Mailing list pgsql-general

From Tom Lane
Subject Re: Accessing composite type columns from C
Date
Msg-id 9614.1200586193@sss.pgh.pa.us
Whole thread Raw
In response to Accessing composite type columns from C  (Reg Me Please <regmeplease@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Hart
Date:
Subject: Re: advocacy: drupal and PostgreSQL
Next
From: Tom Lane
Date:
Subject: Re: Can't make backup (again)