Re: Undocumented trick in SELECT?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Виктор Вислобоков <corochoone(at)gmail(dot)com>
Cc: PostgreSQL-documentation <pgsql-docs(at)postgresql(dot)org>
Subject: Re: Undocumented trick in SELECT?
Date: 2010-04-04 16:26:17
Message-ID: 12678.1270398377@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

=?KOI8-R?B?98nL1M/SIPfJ08zPws/Lz9c=?= <corochoone(at)gmail(dot)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

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Peter Eisentraut 2010-04-04 20:26:14 Re: [COMMITTERS] pgsql: Remove unnecessary xref endterm attributes and title ids The
Previous Message Виктор Вислобоков 2010-04-04 13:01:28 Undocumented trick in SELECT?