Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id D8E021337B5A for ; Tue, 5 Oct 2010 05:58:35 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 98306-06 for ; Tue, 5 Oct 2010 08:58:28 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gmx.net (mailout-de.gmx.net [213.165.64.23]) by mail.postgresql.org (Postfix) with SMTP id 5BC3C1336971 for ; Tue, 5 Oct 2010 05:58:28 -0300 (ADT) Received: (qmail invoked by alias); 05 Oct 2010 08:58:27 -0000 Received: from a88-115-218-165.elisa-laajakaista.fi (EHLO [10.0.0.101]) [88.115.218.165] by mail.gmx.net (mp047) with SMTP; 05 Oct 2010 10:58:27 +0200 X-Authenticated: #495269 X-Provags-ID: V01U2FsdGVkX18l3tRRbiIlfj7WU3ehcWqbGrM8wZK+o4PWzpOWrS zSPiAN/UuBnpId Subject: no documentation for (compval).* field selection From: Peter Eisentraut To: pgsql-docs@postgresql.org Content-Type: text/plain; charset="UTF-8" Date: Tue, 05 Oct 2010 11:58:24 +0300 Message-ID: <1286269105.16817.8.camel@vanquo.pezone.net> Mime-Version: 1.0 X-Mailer: Evolution 2.30.2 Content-Transfer-Encoding: 7bit X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201010/4 X-Sequence-Number: 6145 I couldn't find any documentation for using .* to select all fields (attributes) of a composite type value, e.g., CREATE TYPE comp_t AS (intval integer, textval varchar(32)); CREATE TABLE t4 (compval comp_t); SELECT (compval).* FROM t4; The only place this is used is in the hstore documentation. Would it be appropriate to document this in section "4.2.4. Field Selection", or is this a special case of some other construct that is already documented?