Path: csiph.com!optima2.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!1.eu.feeder.erje.net!newsfeed.fsmpi.rwth-aachen.de!newsfeed.straub-nv.de!eternal-september.org!feeder.eternal-september.org!mx02.eternal-september.org!.POSTED!not-for-mail From: Dimitri Fontaine Newsgroups: comp.databases.postgresql Subject: Re: PG composite types: select with table alias Date: Wed, 01 Jul 2015 20:13:01 +0200 Organization: A noiseless patient Spider Lines: 8 Message-ID: References: <4a4ba442-62ad-4120-98f5-fd517daeb2ed@googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain Injection-Info: mx02.eternal-september.org; posting-host="d82aa4f1883ab7155c995516303c9b46"; logging-data="6615"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+qURROWn2egQ21NRGIkq9T" User-Agent: Gnus/5.13001 (Ma Gnus v0.10) Emacs/24.3.93 (darwin) Cancel-Lock: sha1:FE8nVgUtacPyIp7R3JDjABvFWV8= sha1:8qAayd/8B9WveCgR2+KpUIFIvNE= Xref: csiph.com comp.databases.postgresql:673 armsoft@ukr.net writes: > Thank you Dimitri, that it. Strange that it wasn`t stated in PG documentation. http://www.postgresql.org/docs/9.4/static/rowtypes.html#AEN7836 -- Dimitri Fontaine PostgreSQL DBA, Architecte