Обсуждение: Accessing composite type columns from C

Поиск
Список
Период
Сортировка

Accessing composite type columns from C

От
Reg Me Please
Дата:
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.
--
Reg me, please!

Re: Accessing composite type columns from C

От
Tom Lane
Дата:
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

Re: Accessing composite type columns from C

От
"Merlin Moncure"
Дата:
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