strange behavior, hoping for an explanation

From: Chris Travers <chris(dot)travers(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: strange behavior, hoping for an explanation
Date: 2011-11-11 06:56:35
Message-ID: CAKt_Zfu18vu3X4+VC7ooH_v1rrB7oEqATNp5zC8AS26R6Tr6nQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi;

I have found recently that tables in certain contexts seem to have a
name pseudocolumn. I was wondering if there is any documentation as
to what this is and what it signifies.

postgres=# CREATE table TEST2 (a text, b text);
CREATE TABLE
postgres=# INSERT INTO test2 values ('aaaa', 'bbbb');
INSERT 0 1
postgres=# select t.name FROM test2 t;
name
-------------
(aaaa,bbbb)
(1 row)

However:

postgres=# select name FROM test2 t;
ERROR: column "name" does not exist
LINE 1: select name FROM test2 t;

This isn't making any sense to me. Are there certain circumstances
where a tuple is cast to something like varchar(63)? Does this pose
pitfals for any columns named 'name' in other contexts?

Best Wishes,
Chris Travers

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-11-11 07:11:20 Re: strange behavior, hoping for an explanation
Previous Message Tom Lane 2011-11-11 03:50:18 Re: Fedora 16 note...