Thread: Accessing composite type columns from C
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!
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