Обсуждение: BUG #5360: system column named "text"

The following bug has been logged online:

Bug reference:      5360
Logged by:          Sergey Manakov
Email address:      vialorn@gmail.com
PostgreSQL version: 8.4.2
Operating system:   Fedora Core 8
Description:        system column named "text"
Details:

Hi! I'am from Russia and write English ugly, but i'am must to try...

I have some table with column named "remark" and without column named
"text". I wrote SQL where try to select column named "text" by mistake:

SELECT st.text
FROM sometable st

Where error expected, but query executed without error! Query result is one
column contains text representation of ROWs.

Is this a bug, or I'am look for description in docs badly?

"Sergey Manakov" <vialorn@gmail.com> writes:
> I have some table with column named "remark" and without column named
> "text". I wrote SQL where try to select column named "text" by mistake:

> SELECT st.text
> FROM sometable st

> Where error expected, but query executed without error! Query result is one
> column contains text representation of ROWs.

> Is this a bug, or I'am look for description in docs badly?

No, it's not a bug.  It's equivalent to text(st) or st::text, that
is the system thinks you're requesting a coercion of the rowtype
value to text.  The syntactic equivalence of f(foo) and foo.f is
documented near the end of section 34.4.2:
http://www.postgresql.org/docs/8.4/static/xfunc-sql.html#AEN43797

            regards, tom lane