From: Steve Atkins <steve@blighty.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Mime-Version: 1.0 (Mac OS X Mail 10.3 \(3273\))
Subject: Re: 4.2.9. Type Casts - documentation improvement
Date: Tue, 12 Sep 2017 16:14:51 -0700
References: <20170905021712.25640.86402@wrigleys.postgresql.org>
 <20170912223325.GC6766@momjian.us>
To: pgsql-docs@postgresql.org
In-Reply-To: <20170912223325.GC6766@momjian.us>
Message-Id: <96018C79-ABA3-41EB-A327-4F509D224A2A@blighty.com>
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org


> On Sep 12, 2017, at 3:33 PM, Bruce Momjian <bruce@momjian.us> wrote:
>=20
> On Tue, Sep  5, 2017 at 02:17:12AM +0000, artejera@gmail.com wrote:
>> The following documentation comment has been logged on the website:
>>=20
>> Page: https://www.postgresql.org/docs/9.2/static/sql-syntax.html
>> Description:
>>=20
>> Hi,
>>=20
>> There seems to be no explicit documentation of the useful construct:
>>=20
>> Select tt.*::text from tt
>>=20
>> Also related:  4.2.13. Row Constructors
>>=20
>> Congrats for your project. Yours AT
>=20
> Woh, I was not aware that worked, e.g.:
>=20
> 	test=3D> SELECT pg_language.*::text FROM pg_language;
> 	             pg_language
> 	-------------------------------------
> 	 (internal,10,f,f,0,0,2246,)
> 	 (c,10,f,f,0,0,2247,)
> 	 (sql,10,f,t,0,0,2248,)
> 	 (plpgsql,10,t,t,12319,12320,12321,)
>=20
> Any idea where this should be documented.   It is useful?

It's the output format of a composite type, isn't it?

steve=3D# select pg_language from pg_language;
             pg_language
-------------------------------------
 (internal,10,f,f,0,0,2246,)
 (c,10,f,f,0,0,2247,)
 (sql,10,f,t,0,0,2248,)
 (plpgsql,10,t,t,12656,12657,12658,)
(4 rows)

https://www.postgresql.org/docs/current/static/rowtypes.html might be the p=
lace to expand on it, if so. (And converting to hstore or json or csv are o=
ther useful things to discuss too, maybe).

Cheers,
  Steve

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