Re: Undocumented trick in SELECT? - Mailing list pgsql-docs

From Tom Lane
Subject Re: Undocumented trick in SELECT?
Date
Msg-id 12678.1270398377@sss.pgh.pa.us
Whole thread Raw
In response to Undocumented trick in SELECT?  (Виктор Вислобоков <corochoone@gmail.com>)
List pgsql-docs
=?KOI8-R?B?98nL1M/SIPfJ08zPws/Lz9c=?= <corochoone@gmail.com> writes:
> I'm sorry, but I have not found such construction into documentation:
> SELECT tablename FROM tablename;

It's a whole-row variable.  These aren't terribly well documented but you
can find descriptions of them in places.  It's not standard SQL --- I
think we inherited it from PostQUEL and kept it because functions on
composite types don't work very well without composite variables.

            regards, tom lane

pgsql-docs by date:

Previous
From: Виктор Вислобоков
Date:
Subject: Undocumented trick in SELECT?
Next
From: Peter Eisentraut
Date:
Subject: Re: [COMMITTERS] pgsql: Remove unnecessary xref endterm attributes and title ids The