Skip site navigation (1) Skip section navigation (2)

no documentation for (compval).* field selection

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-docs(at)postgresql(dot)org
Subject: no documentation for (compval).* field selection
Date: 2010-10-05 08:58:24
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-docs
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?

pgsql-docs by date

Next:From: Mike ToewsDate: 2010-10-05 19:01:39
Subject: Latest release date formatting on
Previous:From: Thom BrownDate: 2010-10-04 17:50:29
Subject: Re: Additional index entries and table sorting

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group