Date: Tue, 12 Sep 2017 18:33:25 -0400
From: Bruce Momjian <bruce@momjian.us>
To: artejera@gmail.com
Cc: pgsql-docs@postgresql.org
Subject: Re: 4.2.9. Type Casts - documentation improvement
Message-ID: <20170912223325.GC6766@momjian.us>
References: <20170905021712.25640.86402@wrigleys.postgresql.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20170905021712.25640.86402@wrigleys.postgresql.org>
User-Agent: Mutt/1.5.23 (2014-03-12)
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

On Tue, Sep  5, 2017 at 02:17:12AM +0000, artejera@gmail.com wrote:
> The following documentation comment has been logged on the website:
> 
> Page: https://www.postgresql.org/docs/9.2/static/sql-syntax.html
> Description:
> 
> Hi,
> 
> There seems to be no explicit documentation of the useful construct:
> 
> Select tt.*::text from tt
> 
> Also related:  4.2.13. Row Constructors
> 
> Congrats for your project. Yours AT

Woh, I was not aware that worked, e.g.:

	test=> 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,)

Any idea where this should be documented.   It is useful?

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +


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