From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Ronan Dunklau <rdunklau(at)gmail(dot)com> |
Subject: | Re: Anonymous record type and inner types. |
Date: | 2011-07-01 13:36:26 |
Message-ID: | 201107010636.27301.adrian.klaver@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Friday, July 01, 2011 1:37:44 am Ronan Dunklau wrote:
> Hello.
>
> Sorry if this question has already been asked, but I couldn't find the
> answer anywhere.
>
> When I execute a statement such as "Select (an_int, a_varchar) as a_record
> from test, the type returned for a_record is "record" (oid 2249).
>
> Is the "inner type" information propagated somehow (that an_int is an
> integer, and a_varchar a varchar) ?
See below for complete information:
http://www.postgresql.org/docs/9.0/interactive/sql-expressions.html#SQL-SYNTAX-
ROW-CONSTRUCTORS
>
> If so, is it easily accessible in client libraries ? I'm using psycopg2 for
> python, which itself uses libpq.
>
> Thanks.
>
> Regards,
>
> --
> Ronan Dunklau
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Olivier LEVESQUE | 2011-07-01 14:24:59 | pg_upgrade does not translate tablespace location to new cluster |
Previous Message | David Johnston | 2011-07-01 13:32:34 | Re: question about query |