Search Postgresql Archives

Re: Anonymous record type and inner types.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.klaver@xxxxxxxxx

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux